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.
My 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, follow me.
No comments:
Post a Comment