Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unload/Hide Userform when switching to a new Wbk
Hello,
How can i cause a UserForm to unload/Hide when the user switches to another workbook, without using the Workbook_Deactivate event in the Workbook VBA code area? I look for a different approach because the UserForm will be trigered by an add-in and the active workbook will not have a Workbook VBA code area with the Deactivate event Thanks a lot Avi |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unload/Hide Userform when switching to a new Wbk
Take a look at this for application level events which will catch the
Deactive evnet of the workbook... http://www.cpearson.com/excel/AppEvent.htm -- HTH... Jim Thomlinson "avi" wrote: Hello, How can i cause a UserForm to unload/Hide when the user switches to another workbook, without using the Workbook_Deactivate event in the Workbook VBA code area? I look for a different approach because the UserForm will be trigered by an add-in and the active workbook will not have a Workbook VBA code area with the Deactivate event Thanks a lot Avi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Show/Unload Userform | Excel Programming | |||
unload userform problem | Excel Programming | |||
Unload Userform doesn't work here - why? | Excel Programming | |||
Userform Question (Load/Unload/Show/Hide) | Excel Programming | |||
load/unload userform | Excel Programming |