How to isolate macros to one workbook?

[percy83]

Hello,

I am just finalizing a dashboard file with some macros in it and I if I have other files open sometimes the worksheet change event triggers (in any other book then the one with macros). How do I isolate my events and macros to a specific file i.e. workbook s that they dont mess with other files I have open?

Could I use somekind of workbook deactivate event ?

How do you all solve these kinds of problems?

Thanks!

Percy

 

[VoG]

Maybe like this

Application.EnableEvents = False
'
'your code
'
Application.EnableEvents = True

 

[percy83]

Maybe like this

Application.EnableEvents = False
'
'your code
'
Application.EnableEvents = True

Thanks for your suggestion but I already did above and also put it in a workbook deactivate event to shut off event when another workbook is used simoultaneosly. Somehow a combobox change event is triggered in the macro workbook even if it is not active.

Any suggestions?

BR
Per