Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 bug? VBA custom menu disappearing
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disappearing Worksheet Menu Bar | Excel Discussion (Misc queries) | |||
menus and toolbars disappearing in excel 2003 | Excel Discussion (Misc queries) | |||
VBA - Disappearing custom menu and custom toolbar | Excel Programming | |||
Custom Menu return to Excel Menu upon Closing | Excel Programming | |||
disappearing menu | Excel Programming |