View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike Fogleman Mike Fogleman is offline
external usenet poster
 
Posts: 1,092
Default Excel 2003 bug? VBA custom menu disappearing

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

Mike F
"O_lanke" wrote in message
om...
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