Originally Posted by savvy:
“The option is in Excel itself.
In Excel 2003, it's under Tools | Macro | Security.
Change to Medium Security Level, and it will then ask you each time if you want to run Macros; obviously say yes to allow Graham's application. This is safer than Low, which will run all macros, even those you don't know
”
“The option is in Excel itself.
In Excel 2003, it's under Tools | Macro | Security.
Change to Medium Security Level, and it will then ask you each time if you want to run Macros; obviously say yes to allow Graham's application. This is safer than Low, which will run all macros, even those you don't know
”
If you are using Excel 2007 (not sure about other versions) there is another option available. From within Excel, you can specify a particular folder on your PC as being trusted. Any excel file containing macros opened from that directory will open seemlessly.
You can actually specify more than one folder as being trusted, but what I do is to have a single folder in which I store all Excel files with macros that I trust. I then create shortcuts to the files in the (untrusted) folders that I would have stored them in if it wasn't for the macros.






)