Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.programming
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Disappearing Worksheet Menu Bar Sandy Excel Discussion (Misc queries) 0 September 5th 07 08:14 PM
menus and toolbars disappearing in excel 2003 Sam Excel Discussion (Misc queries) 1 July 5th 05 03:55 AM
VBA - Disappearing custom menu and custom toolbar Peter[_50_] Excel Programming 2 December 2nd 04 06:09 PM
Custom Menu return to Excel Menu upon Closing VetcalcReport Excel Programming 2 August 2nd 04 02:59 PM
disappearing menu terry freedman Excel Programming 4 May 11th 04 06:53 AM


All times are GMT +1. The time now is 05:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"