View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
avi avi is offline
external usenet poster
 
Posts: 195
Default 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