View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob van Gelder[_4_] Rob van Gelder[_4_] is offline
external usenet poster
 
Posts: 1,236
Default 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?"