Adding an Item to the Main Menu

[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?

Thank you.

 

[Gary Brown]

Jack,
If there is another program/add-in that is also changing the menu, it
might be setting the menu back to it's default and then adding itself. This
means you see your menu item and then (when the other program starts
running) gets deleted as the other program customizes itself. I've seen
this happen with 3rd party vendors creating interfaces between Oracle and
Excel.
HTH,
Gary Brown

 

[Jack Gillis]

Thank you, Gary. I can almost guarantee there is no other program doing
that.