Installed add-in not loading when Excel 2000 started

[Rodney Baker]

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.

 

[Tom Ogilvy]

In the latest versions of Excel, I believe there is a security setting
pertinent to addins. You might have a look at this if they are using xl2002
or xl2003.

 

[Ron de Bruin]

Tools>Macro>Security

On the Trusted sources tab Check trust all add-ins.....

 

[Rodney Baker]

Thanks Tom. They're running XL2000 - I checked the Options dialog but the
available tabs are limited by the fact that admin access is not available,
the security level has been preset and the security tab is one that is
missing. I have admin access to my machine at work (I have both XL2000 and
2002) so I'll double check but I'm pretty sure that it is there on 2000 if
you are allowed access to it.

Failing that, I'll just create the shortcut in XLStart...

Cheers,
Rodney.