View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ronbo Ronbo is offline
external usenet poster
 
Posts: 162
Default Change Workbook Event

I have a procedure on Workbook_Open that removes all toolbars, commandbars,
etc. and it restores them on Workbook_BeforeClose. However if a user has
opened this workbook and them opens or goes to another they will not have any
toolbars. My question is there a way such as an event procedure that if one
switch workbooks it will restore the toolbars and then upon returning remove
the toolbars?

As always, thank a lot any help.

Regards