If you go into the VBE and click on the ThisWorkbook item in the project
explorer, you can use the dropdowns at the top of the righthand side window.

You can choose "Workbook" in the lefthand side dropdown and then choose either
Workbook_WindowActivate or Workbook_WindowDeactivate.


Kevin wrote:

Is there such thing as a window change event?

I have code that resides in an add-in and I would like to have a macro in
there that would run whenever another open workbook is selected via windows
drop down or alt/tab??

--

Dave Peterson