open a file programically and disable macros

[foxguy]

When I have a macro open another file, it always activates the macros in it. Is there some way to disable the macros?

[JBeaucaire]

Please Login or Register  to view this content.

This code in your macro should disable other macros from firing until you issue a "TRUE" version later.

[shg]

That will keep events from triggering in the open workbook.

If you don't want macros to be able to run at all in the workbook (e.g., via Alt+F8), then before opening,

Please Login or Register  to view this content.

[foxguy]

replied too soon

[foxguy]

shg;

I tried this code:

Please Login or Register  to view this content.

and my macro just ended as soon as the file was opened. It never reached the line that reset the AutomationSecurity.
The file opened fine and macros would not run in it, but the security was not reset.

[royUK]

Try this

Please Login or Register  to view this content.

[foxguy]

Try this

Please Login or Register  to view this content.

Am I reading that right? 2 "Sub" statements, but only 1 "End Sub". If that's just a typo, how is it different from what I already tried?

[royUK]

Sorry, I copied & pasted in a rush, then made amendments. You don't declare the variable, when I run the code it disables the code within the opened workbook but not the parent workbook.

[foxguy]

Roy;

That's the same code I run (I declare the variable, just didn't put it in the reply). But when it opens the workbook, the macro ends. It never executes the line:

Please Login or Register  to view this content.

[royUK]

Try attaching the workbook, it worked for me in a dummy workbook

[romperstomper]

How are you running the code as a matter of interest?

[foxguy]

How are you running the code as a matter of interest?

I created a menu button that executes a macro that opens the file.