Security of Marco is of three levels in Excel.
1. High: When set to high only Macros from trusted sources will be allowed.
2. Medium: When set it will ask you while opening the excel (if it contains macro) whether to enable or disable the macro.
3. Low: When set it will not ask you for any option while opening the excel and can potentially create problems.
If you want to change the security settings for Macro following are the steps:
a. Open Excel
b. Click Too-> Macro –> Security.
c. Click on the option which suits you best but beware of setting it to low.
Related posts:
