Auto Enable Macro in 2007

[Emoncada]

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]

If you could enable macros that way, security is shot ...

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

[jproffer]

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)