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.

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.

--
Regards,
Tom Ogilvy

"Rodney Baker" wrote in message
...
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.

ToolsMacroSecurity

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Tom Ogilvy" wrote in message ...
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.

--
Regards,
Tom Ogilvy

"Rodney Baker" wrote in message
...
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.

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.


"Tom Ogilvy" wrote in message
...
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.

--
Regards,
Tom Ogilvy

"Rodney Baker" wrote in message
...
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.