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.

Our advice is to use the second security level if you are downloading a lot of Excel files from the internet. With this security level you can always disable the macro if you don't trust the owner of the Excel file. Use the fourth security level if you are a beginner and only typing your own macros at the moment. With this security level you don't have to enable macros all the time.

Did you find this information helpful? Show your appreciation, vote for us.

Go to Top: Macro Security    |    Go to Next Topic: Visual Basic Editor

Before you start, make sure that your macro security settings are set up correctly. It is not likely that nasty things will happen to your system, but there is a chance that a macro contains a virus.

1. Click on Tools, Macro, Security.

2. Here you have four options. Very High will disable all macros, unless you've stored your macro in a specific trusted folder. High will only allow macros which are signed by an acknowledged trusted source. Medium will allow you to decide whether or not to run a macro. Low will enable all macros.

Our advice is to use the medium level if you are downloading a lot of Excel files from the internet. This security level allows you to disable the macro if you don't trust the owner of the Excel file. You can use the low level if you're only creating your own macros at the moment. With this security level you don't have to enable macros all the time.

Did you find this information helpful? Show your appreciation, vote for us.

Go to Top: Macro Security    |    Go to Next Topic: Visual Basic Editor