Hiding then Showing Different Toolbars
Posted by JAF on January 10, 2001 4:31 AM
I have a spreadsheet which is updated by several different users.
The spreadsheet has Workbook_Open code that removes the Standard and Formatting toolbars and Workbook_BeforeClose code that displays them again.
I want to be able to hide ALL toolbars that a user may have open and then reinstate those same toolbars in the BeforeClose code. The problem that I have is that different users have different toolbars enabled.
User 1 has Standard, Formatting and Drawing toolbars enabled.
User 2 has Standard, Formatting and Forms toolbars enabled.
User 3 has Standard, Formatting, Drawing, Web and Custom toolbars enabled.
Is there any way for Excel to note which toolbars are displayed when the file is opened, close those toolbars and then reinstate them in the BeforeClose code?
In other words, when using the file no toolbars would be visible, but when the file is closed, each users "unique" toolbars would be restored.