Disable an OpenWorkbook macro

[alyssa75]

I have a batch macro that runs on a bunch of file. Each of those files has an Open Workbook macro which I don't want to run when I run the batch macro. Anyway to disable macros in a workbook being opened by another macro?

Thanks

 

[brucesw]

Did you ever get an answer to this question? I'm looking for the same thing but realise you posted in 2007!!!

Thanks, Bruce

 

[alyssa75]

I actually just posted this last month. But no...unfortunately, I did not get a response and was not able to figure it out on my own. Sorry.

Please let me know if you have better luck.

Thanks!

 

[brucesw]

I must have misread the 2007 (it's your join date).

Se my thread from earlier today:
http://www.mrexcel.com/forum/showthread.php?p=2894683#post2894683
It's the security bit I needed but Andrew cave the open Workbook answer.

 

[Andrew Poulsom]

Put this at the beginning of your batch macro:

Application.EnableEvents = False

and set it back to True at the end.