File Specific Toolbar

[Syed Zeeshan Haider]

Hello Experts,
I have Excel 97 Pro on Win98SE.

In MS Word, we can have a certain 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. Is it possible
programmatically in Excel?

Thank you,

 

[Andy Wiggins]

This file might be a help:
http://www.bygsoftware.com/examples/zipfiles/MenuActiveWbDemo.zip

It's in the "Menu Routines" section on page:
http://www.bygsoftware.com/examples/examples.htm

It contains VBA code that will activate a menu only when the workbook it is
in is active.
The code is open and commented.

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"