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 |
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 |
All times are GMT +1. The time now is 02:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com