auto run all macros when workbook open

[hocs]

Hi,

May i know the code to auto run all macros of a workbook when the workbook is opened, rather than storing the file at trust location or manually enable macro?
Thanks!

 

[jproffer]

You can call each one from the Workbook_Open code module, but the user will still have to enable macros for it to work.

If security is too high, or if they choose not to enable macros, it won't run.

Being able to automatically defeat the macro security would make that security kind of pointless, yes?