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?
Bob Phillips
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)
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.