Stopping macros from affecting other workbooks

[Brooksy1]

Apologies i have now resolved this myself. I had references to ActiveWorkbook which i changed to ThisWorkbook.

Ridiculous that i didn't think of that before!

Many thanks

Tom

 

[Hui]

Tom

It sounds as though the macro's are using code like

Activeworkbook/sheet.select

Rather than specifying specifically which workbook/sheet to use

This creates issues when the user clicks on anything when a macro is running as you can change the focus and end up with the problem you describe

It sounds as though you need someone to review/edit the macro's

 

[Brooksy1]

Tom

It sounds as though the macro's are using code like

Activeworkbook/sheet.select

Rather than specifying specifically which workbook/sheet to use

This creates issues when the user clicks on anything when a macro is running as you can change the focus and end up with the problem you describe

It sounds as though you need someone to review/edit the macro's

Thanks Hui,

I have now resolved this but you where to quick to reply before i got in there first.

You are exactly right i was able to change activeworkbook to thisworkbook on each of the macros that where running and it is now resolved.

Thanks for your help.