You need to set up the macro security settings correctly to protect yourself against potential viruses. Make sure your macro security settings are set up correctly so that they may not create any harm to your computer.
To set up the macro security settings in Excel 2010 or Excel 2007, execute the following steps.
1. Click on Macro Security.
To set up the macro security settings in Excel 2010 or Excel 2007, execute the following steps.
1. Click on Macro Security.
2. Here you have four options. The first option will disable all macros. The second option will always ask you to enable a macro. The third option will only allow macros with a digital signature to run, and ask you to enable others. The fourth option will enable all macros.
As per me we should use the second security level if we are downloading a lot of Excel files from the internet. With this security level we can always disable the macro if we don't trust the owner of the Excel file.
We can use the fourth security level only if we are only typing our own macros and checking them. With this security level we don't have to always enable macros.
We can use the fourth security level only if we are only typing our own macros and checking them. With this security level we don't have to always enable macros.
No comments:
Post a Comment