Is there a vb script that can run on opening a spreadsheet to enable macro instead of the user having to select to enable?
Is there a vb script that can run on opening a spreadsheet to enable macro instead of the user having to select to enable?
If you could enable macros that way, security is shot ...
You can always establish a trusted location, and store your workbooks there.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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)
Posting Permissions
Reply With Quote
