Auto open macro no control over macro security

[Ed in Aus]

I have some macros that are auto open on file, but I can't change my macro security settings. I don't think I would be quick enough to ctrl break the macros without them doing some mischeif. Can you open these another way so they don't run with out changing the security?

 

[royUK]

Have you got macro security set to low? If you have then that is asking for trouble.

 

[Ed in Aus]

Yeah its set to low at work we need it here, has to be set that way. Any ideas like open in debugger for a certain file???

 

[zzjasonzz]

you can open up excel, pause macros then go file > open in excel to open the book

 

[Ed in Aus]

How do you pause them from excel???

 

[Datsmart]

Hold the Shift key when you open the workbook, that keeps any event code from running.