In MS Excel, macros are the feature that is used when developing spreadsheets. On the other hand, we can say, that macros are automated actions or scripts in that save time by performing repetitive tasks. However, it is important to enable this feature to improve the spreadsheet’s functionality. In this blog, I will show you a complete step-by-step on how to enable macros in Excel Windows 10/11.
To recover corrupted Excel file data, we recommend this tool:
This software will prevent Excel workbook data such as BI data, financial reports & other analytical information from corruption and data loss. With this software you can rebuild corrupt Excel files and restore every single visual representation & dataset to its original, intact state in 3 easy steps:
- Try Excel File Repair Tool rated Excellent by Softpedia, Softonic & CNET.
- Select the corrupt Excel file (XLS, XLSX) & click Repair to initiate the repair process.
- Preview the repaired files and click Save File to save the files at desired location.
How to Enable Macros in Excel Windows 10?
Follow the below methods to enable macros in the Excel sheet.
Method 1: How to Enable Macros in Excel Windows 10 via Backstage View
The very first and easy solution you can try is turning on macros via Office Backstage view. Follow the below steps to do so:
- Navigate to the File menu >> click Info option left menu.
- Under Security Warningpart, you have to click on the Enable Content option >> Enable All Content.
Method 2: Turn ON Macros for One Session
Sometimes, you may need to enable Excel macros for a single time. Thus, if you want to do so and make this workbook a trusted document, follow the below instructions carefully:
- Go to the File menu > Info.
- Under the Security Warning section, click on the option “Enable Content” > Advanced Options.
- Under the Microsoft Office Security Options dialog box, you have to Enable content for this session >> click OK.
- This enables macros for one time.
Please note: Once you close your document, and then open it again, the caution will appear again.
Method 3: Enable VBA Codes via Trust Center
As many of you are unaware of the fact that MS Excel allows or disallows the macro to run based on the macro setting chosen in the Trust Center. However, to get VBA enabled in all MS Excel documents by default, follow the below steps:
- Click Filetab >> Options.
- After this, you have to select Trust Center >> Trust Center Settings… .
- Under Trust Center dialog box, you have to click on the Macro Settings on the left, choose Enable all macros >> hit OK.
That’s all!
How to Enable Macros in Excel Sheet on Mac?
Not only Windows but Excel for Mac users also enable or disable macros to enhance the spreadsheet functionality. Here are the complete steps:
- On Excel PC, open Excel.
- Choose Excel at the top & select Preferences.
- Choose Security in the Sharing and Privacy.
- Now, you have to check Macro Security option & click a radio option beside the relevant option.
Repair Corrupted Workbook: Use MS Excel Repair Tool
Excel is a daily use program and it is common to encounter errors or issues while handling it. If you face any errors or issue due to the Excel file corruption, you can use the MS Excel Repair Tool. This is an advanced software that allows repairing, corrupt inaccessible files in Excel, and some kind of Excel errors.
Furthermore, it is very easy to use and supports all Excel versions.
Related FAQs:
You might be unable to enable macros due to faulty Excel add-ins.
If the Developer tab is missing from the top of the Excel ribbon, then do the following things: Select Excel >> Preferences option > Ribbon & Toolbar. In the Customize the Ribbon, choose Main Tabs >> check Developer.
To unlock macros in Windows 11, you have to right-click on the Excel file >> choose properties. After that, you should check the checkbox, which says ‘unblock’, and press OK.
In order to check if macros are enabled, open Excel and Press Alt+F11. Why Can't I Enable Macros in Excel?
How Do I Enable Macro Developer in Excel?
How Do You Unblock Macros in Windows 11?
How to Check If Macros Are Enabled in Excel?
Final Thoughts
Enabling macros in the Excel aids in streamlining your work & increase efficiency. Therefore, always ensure you use macros reliably and only with trusted files. Follow this guide step by step on how to enable macros in Excel sheet and take full advantage of Excel’s features.
I hope you liked this post!
Priyanka Sahu
Priyanka is a content marketing expert. She writes tech blogs and has expertise in MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in the easy-to-understand language is very impressive. When not writing, she loves unplanned travels.