Enabling Macros

[Todd]

Is there anyway possible that for every user that opens a
workbook with macros the Enable Macro question box will
not pop up and the macros will always be enabled? The
workbook that I am creating will be used by many people
with different versions of Excel and limited knowledge of
Excel so the macros may be disabled causing errors.
Thanks for the help!

 

[Frank Kabel]

Hi
the only way would be that your users set the security level to 'Low'.
BUT I wouldn't recommend this. this is a security feature. So there
should be no way tro disable it programmatically