Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Workbook Event
In the same workbook that removes the menus, use the
Workbook_Deactivate event this will trigger whenever another workbook is activated over it Note: to delete the menu's again once this workbook is activated you will need to use the Workbook_Activate event "Ronbo" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change event? | Excel Discussion (Misc queries) | |||
Change Cell from Validated List Not Firing Worksheet Change Event | Excel Programming | |||
Chart Values that change based on Change event | Excel Programming | |||
Change minimumscale with the change event of a combobox | Excel Programming | |||
change event/after update event?? | Excel Programming |