G
Guest
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
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