Creating/Destroying Toolbars Programmatically

  • Thread starter Thread starter Syed Zeeshan Haider
  • Start date Start date
S

Syed Zeeshan Haider

Hello Experts,
I have Excel 97 Pro on Win98SE.

In MS Word, we can have a certain custom toolbar as a part of ONLY ONE file.
In
other words, we can have a toolbar private to a single file. I have noticed
that it can't be done in Excel 97 by simple means, instead, in Excel a
custom toolbar is *always* global. Is it possible to create a custom toolbar
private to a single file programmatically in Excel?

Thank you,
 
I do this all the time. My usual method is to create the toolbar using
the Workbook_Open() event, destroy it using the Workbook_BeforeClose()
event, and enable/disable it using the Workbook_Activate() and
Workbook_Deactivate() events.
 
Back
Top