OPEN WITH SPECIFIC ADD INS

[Raj Sood]

i want to be able to specify different profiles of excel, does anyone
know how to do that? I have many different add ins in excel, so if i
can specify which addins i want on each instance of excel, and then
name them... i wouldn't have to open every single addin every time i
opened excel. a colleague mentioned that it is possible to name
different 'profiles' of excel and then open them up under different
names... and different addins can be loaded to the various profiles...
is that possible? i think it's done similar to opening in safe
mode... like excel.exe /safe at the run command. not sure.. any
ideas?

 

[Dave Peterson]

I don't think I've seen different profiles within excel, but maybe I missed it.

There are profiles at the operating system level. (I don't use them.) But you
can define different profiles based on who is using the pc. (Or who you want to
be!)

On the other hand, maybe you could create a workbook that has a bunch of buttons
on them. And each button would be labeled nicely on what addins were available.

Then assign a macro to each button that loads/unloads the addins you want/don't
want.

I recorded a macro when I toggled a couple and got code that looked like:

AddIns("Analysis ToolPak").Installed = False
AddIns("Conditional Sum Wizard").Installed = True

 

[Gabhan Berry]

Raj,

Not sure about profiles, but I think that you can specify what addins
are loaded for what users by editing the registry.

If you look in the HKEY_USERS key you'll see a list of keys. These are
SID's (security identifiers) and are generated by the user manager for
domains. Under these keys you'll see a list of sub-keys. Navigate down
into HKEY_USERS\<SID>\Software\Microsoft\Office\10.0\Excel\Options
(where SID is one of the security id's of your users - to start with,
just pick any). Here you can specify a key called OPEN and assign it a
value of the path to an addin. If you want more than one addin loaded,
create two keys - one called OPEN the other called OPEN1 and assign
the paths appropriately. These can be set for each user of your
computer.

(Note, not all SID's will have these keys already in your registry)

You can do it this way, but it is quite fiddly and requires some
programming. I don't know if there are other ways.

HTH

Gabhan Berry
AI Forecasting and Prediction in Excel
http://www.pececilllo.com