Disable Marco from running 1

[greg303]

I have a excel workbook(a) that opens other excel workbooks(b), selects a range copies the data and pastes it back in the first workbook(a) then close's workbook(b). The problem is workbook(b) has marcos that run when it opens. Is there a way with workbook(a) to have something like 'application.workbooks.open("workbook(b).xls&quot marcos=false' so that they dont run and interfer with workbook(a)'s marcos?

Thanks

 

[RobBroekhuis]

You could put application.enableevents=false right before your workbooks.open call. Just make sure to set it back to true right afterwards, because it won't revert to its default automatically.


Rob

 

[greg303]

Assume!
Works, thanks alot cause it was really getting annoying.

Thanks Again