how start Excel w/o asking enable macros?

I

Ian Elliott

Thanks for any help.
I have a workbook with macros that I start up automatically everytime I log
into my account (I have the shortcut to the Excel file in the startup menu).
Is there a way I can set Excel so that it doesn't ask me if I want to enable
macros for that file? I do this everyday, and could save a second that way,
and make one less step for the user to have to do, too. Thanks again.
 
B

bpeltzer

If you 'sign' the macro, set your security level to medium, and indicate that
you are a trusted auther, you won't be bothered with the prompt. The cheap
way to sign is to create the certificate with the 'selfcert.exe' program that
is part of the MS Office installation, then attach that certificate to the
macro from w/in the VB Editor.
 
Top