Excel 2003 bug? VBA custom menu disappearing

[O_lanke]

Hi!

We have just upgraded from excel 2000 to excel 2003.

Is there a change in how add-ins are defined in the VBE environment
for these?

The problem is related to a self made add-in with a custom menu
between the help ad windows menu. This menu is created with VB when
the add-in is installed.

But when excel is shut down and restarted the menu no longer is shown,
even though the add-in seems to be installed, i.e. is shown as such in
the tools / add-ins menu.

I did not have this problem with excel 2000, and I wonder if more
changes have been done in the VBE environment.

But also, I do not see that the add-in actually is opened when Excel
is started, which I presume should be shown in the lower message bar
in the excel window during execution of opening add-ins (which it did
in excel 2000).

Anu suggestions ?

regards
Ø.Lande

 

[Mike Fogleman]

You may need to update your add-in to reference the newer Office Object
Library.

Mike F