Hi Michael,
Try some simple code (like opening a message box) on the Auto_open code to
see if it is running correctly.
I remember we had the same problem and it was overcome by unloading and
loading the bar in VBA.
Thanks,
Simon
Michael Malinsky wrote:
Long subject line...sorry.
Anyway, I have created an .xla add-in that creates a custom menu item
on the standard menu bar. This works fine when opening Excel.
However, we use a 3rd party application that integrates with Excel
(essentially document management software) that is causing problems.
If I open a workbook through that software, the menu that is supposed
to be created with my add-in does not appear even though the add-in is
checked in the ToolsAdd-ins dialog. If a uncheck and add-in, close
the Add-in dialog, open the Add-in dialog, check my add-in, then close
the Add-in dialog, the menu appears like it should.
I would like to distribute this add-in to everyone at my office, but
this is a sticking point for which I cannot seem to find a solution.
Thanks,
Mike.
--
--------------------
Simon - UK
Email at simon22mports [ a t ] hot mail [ d ot ]com
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200610/1