Creating/Destroying Toolbars Programmatically
 

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,
--
Syed Zeeshan Haider.
http://szh.20m.com/


-----------------------------------
Allah says to Mankind:
"Then which of the favours of your Lord will ye deny?"

Creating/Destroying Toolbars Programmatically
 

You could create it at Workbook_Open and Destroy it at Workbook_BeforeClose.

I've got CommandBar examples on my site:
http://www.vangelder.co.nz/excel/index.html


Rob


"Syed Zeeshan Haider" wrote in
message ...
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,
--
Syed Zeeshan Haider.
http://szh.20m.com/


-----------------------------------
Allah says to Mankind:
"Then which of the favours of your Lord will ye deny?"

Creating/Destroying Toolbars Programmatically
 

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.


In article ,
"Syed Zeeshan Haider" wrote:

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?