VBA run macro

[akramer08]

Is there a way to run a macro in an open workbook when the workbook becomes activated or deactivated? So if I have workbook A open with a macro in it and workbook B open as well, can I have the macro run on workbook A when that becomes the workbook I see on my screen?

 

[AlphaFrog]

Put something like this in the ThisWorkbook code module. Change MyMacro to the name of your macros.

[color=darkblue]Private[/color] [color=darkblue]Sub[/color] Workbook_Activate()
    [color=darkblue]Call[/color] MyMacro1
[color=darkblue]End[/color] [color=darkblue]Sub[/color]
    
[color=darkblue]Private[/color] [color=darkblue]Sub[/color] Workbook_Deactivate()
    [color=darkblue]Call[/color] MyMacro2
[color=darkblue]End[/color] [color=darkblue]Sub[/color]

 

[akramer08]

Perfect, thanks.