krishnap2w2
New member
- Joined
- Oct 6, 2014
- Messages
- 1
- Reaction score
- 0
- Points
- 0
How to Enable Macros in Excel?
In Excel, macros are disabled by default for enhanced security. Below are the steps to
Enable Macros in two different versions of Excel:
1 Excel 2007 Version
2 Excel 2010 Version
Enabling Macros in Excel 2007:
1 The picture below shows a Security Warning in a worksheet in which macros are disabled.
2 Click Options button
3 Check Enable this Content and Click Ok in the Security Alert-Macro box.
Enabling Macros in Excel 2010:
1 The picture below shows a Security Warning in a worksheet in which macros are disabled.
2 Click Enable Editing button.
Just by clicking the Enable Editing button, Excel is ready to enable all the macros.
View attachment How to enable macros in excel.pdf
In Excel, macros are disabled by default for enhanced security. Below are the steps to
Enable Macros in two different versions of Excel:
1 Excel 2007 Version
2 Excel 2010 Version
Enabling Macros in Excel 2007:
1 The picture below shows a Security Warning in a worksheet in which macros are disabled.
2 Click Options button
3 Check Enable this Content and Click Ok in the Security Alert-Macro box.
Enabling Macros in Excel 2010:
1 The picture below shows a Security Warning in a worksheet in which macros are disabled.
2 Click Enable Editing button.
Just by clicking the Enable Editing button, Excel is ready to enable all the macros.
View attachment How to enable macros in excel.pdf