custom menu bar doesn't work

[cristina]

I am currently doing version testing on an Excel template that will b
distributed. It was developed in Excel 2000, and I am currentl
testing it in Excel 2002. The template has a custom menu bar that i
created when the worksheet is opened. This menu bar does not appear t
be working properly in Excel 2002. All buttons of the menu bar caus
Excel to open a new copy of the same template, and I am prompted wit
the standard pop-up to enable or disable macros. When I run the macro
via the standard menu bar Tools --> Macros, all of them work fine. Th
problem only seems to occur when I try to run the macros via buttons o
a custom menu bar. As an experiment, I also tried creating a button o
a worksheet and attaching one of the macros to that button. Well, whe
I click on that button the same problem occurs as with the custom men
bar (Excel tries to open another copy of the same worksheet).
suspect this has something to do with a secruity setting or something.

Please help!! I am at a loss for a solution or workaround. Thanks i
advance for any assistanc

 

[bdcrisp]

What has worked for me is creating a custom add-in that includes th
custom menu creation on open , deletion on exit. Have you tried thi
avenue

 

[Jon Peltier]

In addition to this approach, which IMO is much better than attaching a toolbar you should make
sure the .OnAction property of the buttons includes the workbook name as a prefix to the
procedure to be run. This is how I do this:

.OnAction = ThisWorkbook.Name & "!ProcedureToRun"

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______