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

--
cristin
-----------------------------------------------------------------------
cristina's Profile: http://www.excelforum.com/member.php...fo&userid=1467
View this thread: http://www.excelforum.com/showthread.php?threadid=26295