Hi all. I have written an add-in that imports and formats specific data from
another Excel spreadsheet and does some other stuff like adding totals etc.
All the code in the add-in works well - it creates a custom menu to call the
functions in the add-in and so on, but it does not automatically load when
Excel is started, despite it being checked in the Tools, Add-Ins dialog. The
only way to get it to load currently is to go to Tools, Add-Ins, uncheck it
and then re-open tools, add-ins and check it again. Then it loads and the
custom menu item is available (oh, yeah - the menu item is created in the
add-in's auto_open() procedure).

The .xla file is installed in the user's Add-Ins directory under
C:\Documents and Settings\<username\Common Files\Microsoft\AddIns. Is there
any reason why this add-in is not being auto-loaded when Excel is started? I
figure I can fix it by creating a shortcut to it in the user's XLStart
directory, but should this be necessary? I don't have admin access to the
machine (nor does the regular user) so I can't do anything that needs admin
access, except refer it to the help desk - I just need to know what to tell
them if there is in fact something wrong.

Thanks in advance,

Rodney.