Ensure that Macros are enabled when Excel starts-up?

[huzman]

Hi!

How do I make sure that the user clicks "Enable Macros" when Excel Starts-up? Otherwise, none of my Macros work!

Thank!!

 

[WillR]

You cannot. This would effectively bypass the security.

You can, however, display a splash screen that informs users that the workbook will not function correctly if they do not close the book & reopen with macros enabled.

Try this free example from Dave Hawley

http://www.ozgrid.com/FreeDownloads/EnableMacros.zip

Hope it helps