Wed 12 Mar 2008, 15:32Delegate Gemma said...
Gemma has attended:
Excel Intermediate course
Excel Advanced course
Excel 2007 - Macros
On spreadsheets where macros have been created, when opening the spreadsheet at a later time the macros are not enabled. How can i keep the macro on a spreadsheet enabled without having to go through the security dialog to enable it again?
Thanks
Gemma
Thu 13 Mar 2008, 13:10Delegate Samantha said...
RE: Excel 2007 - Macros
I did this by using a Digital Signature on the macros and setting the security to High.
Once the macros as digitally signed, and you have set up a Signature from a trusted publisher (you can create one yourself), the enable/disable macro box will not be shown.
You have to register your dig sig yourself.
if you search for Digital Signatures, you will find a lot about it on the microsoft web site.
