Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Window change event?
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?? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Window change event?
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Window change event?
Thanks, I think I can make that work... I have an add in that all of my code
resides in and it opens different spreadsheets for each location. I wanted to have something to keep people from selecting workbooks not having to do with these particular spreadsheets while any of them are still open. I'll have the windows_deactivate call a macro to check wether or not the activeworkbook is part of the project or not... Thanks again... "Dave Peterson" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Window Trigger Event. | Excel Programming | |||
apply cell change event to single column - WorksheetChange Event | Excel Programming | |||
new window event | Excel Programming | |||
MsgBox in Enter event causes combobox not to run Change event | Excel Programming | |||
Window Event | Excel Programming |