Thread: ADD-IN will not appear in MENU BAR

I'm having a problem with several ADD-INs not appearing on a menu bar when
Excel opens. One ADD-IN loads perfectly and 5 won't load.
The PC is running XP, ADD-INs will not load when Excel opens even though the
ADD-INs are properly installed. The ADD-IN that does load easily is in the
same folder as the 5 problem files. The box in TOOLS > ADD-INs remains
checked to "on" between Excel sessions for all 6 ADD-INS. Unchecking and
then re-checking the box in TOOLS > ADD-INs causes that ADD-IN's menu to
reappear on the menu bar. Then everything works fine until the next time
Excel opens. Does anyone know what I need to do in order to cause the ADD-IN
to load every time Excel starts?

Thanks
Mike

It sounds as though some code is failing that adds the commandbars in those
addins, but without seeing it is difficult to be precise.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"MIKE215" <MIKE215@discussions.microsoft.com> wrote in message
news:17A1AE0C-E078-472E-B9B8-9450A49609DA@microsoft.com...
> I'm having a problem with several ADD-INs not appearing on a menu bar when
> Excel opens. One ADD-IN loads perfectly and 5 won't load.
> The PC is running XP, ADD-INs will not load when Excel opens even though
the
> ADD-INs are properly installed. The ADD-IN that does load easily is in
the
> same folder as the 5 problem files. The box in TOOLS > ADD-INs remains
> checked to "on" between Excel sessions for all 6 ADD-INS. Unchecking and
> then re-checking the box in TOOLS > ADD-INs causes that ADD-IN's menu to
> reappear on the menu bar. Then everything works fine until the next time
> Excel opens. Does anyone know what I need to do in order to cause the
ADD-IN
> to load every time Excel starts?
>
> Thanks
> Mike

A wild guess -

Code to create the addin's menu items is in the AddinInstall event, also
menus are deleted when the addin unloads (a normal thing to do). If you have
that combination initiate the code to create the menus from the
Workbook_Open event or Auto_open in a normal module.

Regards,
Peter T

"MIKE215" <MIKE215@discussions.microsoft.com> wrote in message
news:17A1AE0C-E078-472E-B9B8-9450A49609DA@microsoft.com...
> I'm having a problem with several ADD-INs not appearing on a menu bar when
> Excel opens. One ADD-IN loads perfectly and 5 won't load.
> The PC is running XP, ADD-INs will not load when Excel opens even though
the
> ADD-INs are properly installed. The ADD-IN that does load easily is in
the
> same folder as the 5 problem files. The box in TOOLS > ADD-INs remains
> checked to "on" between Excel sessions for all 6 ADD-INS. Unchecking and
> then re-checking the box in TOOLS > ADD-INs causes that ADD-IN's menu to
> reappear on the menu bar. Then everything works fine until the next time
> Excel opens. Does anyone know what I need to do in order to cause the
ADD-IN
> to load every time Excel starts?
>
> Thanks
> Mike

Thanks, Bob

But why would the Add-in appear when I toggle the check box on and of in
tools > Add-ins?

These Add-ins were written by other folks and the code is passworded so I
can't get a sample.

Mike

"Bob Phillips" wrote:

> It sounds as though some code is failing that adds the commandbars in those
> addins, but without seeing it is difficult to be precise.
>
> --
> HTH
>
> Bob Phillips
>
> (replace somewhere in email address with gmail if mailing direct)
>
> "MIKE215" <MIKE215@discussions.microsoft.com> wrote in message
> news:17A1AE0C-E078-472E-B9B8-9450A49609DA@microsoft.com...
> > I'm having a problem with several ADD-INs not appearing on a menu bar when
> > Excel opens. One ADD-IN loads perfectly and 5 won't load.
> > The PC is running XP, ADD-INs will not load when Excel opens even though
> the
> > ADD-INs are properly installed. The ADD-IN that does load easily is in
> the
> > same folder as the 5 problem files. The box in TOOLS > ADD-INs remains
> > checked to "on" between Excel sessions for all 6 ADD-INS. Unchecking and
> > then re-checking the box in TOOLS > ADD-INs causes that ADD-IN's menu to
> > reappear on the menu bar. Then everything works fine until the next time
> > Excel opens. Does anyone know what I need to do in order to cause the
> ADD-IN
> > to load every time Excel starts?
> >
> > Thanks
> > Mike
>
>
>

Because the circumstances are (slightly different), so it may react
differently.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"MIKE215" <MIKE215@discussions.microsoft.com> wrote in message
news:FD0618D8-1067-4991-BDAE-A7251919D4F7@microsoft.com...
> Thanks, Bob
>
> But why would the Add-in appear when I toggle the check box on and of in
> tools > Add-ins?
>
> These Add-ins were written by other folks and the code is passworded so I
> can't get a sample.
>
> Mike
>
> "Bob Phillips" wrote:
>
> > It sounds as though some code is failing that adds the commandbars in
those
> > addins, but without seeing it is difficult to be precise.
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (replace somewhere in email address with gmail if mailing direct)
> >
> > "MIKE215" <MIKE215@discussions.microsoft.com> wrote in message
> > news:17A1AE0C-E078-472E-B9B8-9450A49609DA@microsoft.com...
> > > I'm having a problem with several ADD-INs not appearing on a menu bar
when
> > > Excel opens. One ADD-IN loads perfectly and 5 won't load.
> > > The PC is running XP, ADD-INs will not load when Excel opens even
though
> > the
> > > ADD-INs are properly installed. The ADD-IN that does load easily is
in
> > the
> > > same folder as the 5 problem files. The box in TOOLS > ADD-INs remains
> > > checked to "on" between Excel sessions for all 6 ADD-INS. Unchecking
and
> > > then re-checking the box in TOOLS > ADD-INs causes that ADD-IN's menu
to
> > > reappear on the menu bar. Then everything works fine until the next
time
> > > Excel opens. Does anyone know what I need to do in order to cause the
> > ADD-IN
> > > to load every time Excel starts?
> > >
> > > Thanks
> > > Mike
> >
> >
> >