Adding a Menu Item to Main Menu Problem in Excel

[Jack Gillis]

I want to add a new top level entry on the Main Menu that will run a
macro. Doing so should allow me to have a menu with the new entry each
time I open Excel. I've done this before under Excel 97 but when I try
to do it under 2003 I run into the following problem.

I right click on the Main Menu and choose Customize. I then select
Macro from Categories and drag a Custom Menu Item from Commands to the
menu. I then rename it and assign a macro. At least, I believe this is
the way I did it under 97 years ago.

The menu item works just as expected.

However, when I exit Excel and then open Excel again, the recently added
menu item appears briefly but disappears shortly and the menu is as it
was before I changed it.

Can someone suggest what I might being doing wrong?

I can add menu items by doing the above in both Word and Access. Only
Excel is a problem. I have posted this in the Excel group but have not
received any help yet.



Thank you.

 

[Beth Melton]

You might try resetting the Menu bar and trying again.

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/