PDA

View Full Version : Auto Enable Macro in 2007



Emoncada
09-25-2008, 12:17 PM
Is there a vb script that can run on opening a spreadsheet to enable macro instead of the user having to select to enable?

xld
09-25-2008, 12:20 PM
If you could enable macros that way, security is shot ...

You can always establish a trusted location, and store your workbooks there.

jproffer
09-25-2008, 03:41 PM
Or make your code an add-in, then it is "approved" by default when they make the choice to open the add-in. (I assume anyway, I've never had to enable macros that were in an installed add-in)