Removing an addin from the available addins list

[Guest]

Hi,

I was wondering if anyone could help me out. I'd like to remove a custom
addin that I've added from the list of available addins from Excel 2003.

I know Excel will complain the next time it opens that the addin no longer
exists but I'd like to prevent that from happening.

Thanks,
Ryan

 

[Bill Renaud]

Uninstall the add-in first, then use RegEdit to find any leftover entries
and delete them. On my machine (Windows ME), they are in either of the
following 2 registry hives:

[HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Excel\Options]
[HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Excel\Add-in Manager]

In the Options part, you will see entries similar to the form:
Open = "C:\My Documents\My Add-in.xla"

I think later versions of Windows or Excel may have them inside an INI file
somewhere.

 

[Guest]

Thanks Bill. Do you know if you can still have the addin enabled while
having it not show up in the addins list? I have an audit addin that tracks
excel changes however, I don't want anyone disabling it.

As a last resort, I guess I could use a Environ("USERNAME") to remove the
addin only for certain people.

Thanks,
Ryan

 

[Bill Renaud]

<<Do you know if you can still have the addin enabled while having it not
show up in the addins list?>>

The add-in file will still be available on your computer, but it is no
longer "installed". To use it again, the user will have to install it via
the Tools|Add-ins command and dialog box.

Maybe I'm not understanding your question correctly.

Do you mean that you simply want the add-in not to load anymore, but remain
available for future use? Then simply uncheck the add-in in the add-ins
dialog box. It should unload from memory and then not load the next time
Excel is started.

If you want Excel to look like it was never loaded in the first place (does
not appear in the add-ins dialog box), then uncheck the add-in to
un-install it, exit Excel, and remove the entries from the Windows
Registry, like I mentioned previously.

 

[Guest]

Sorry Bill for not explaining correctly.

I'd like to have the audit addin enabled, but not show up in the available
addins list because I don't want the user to disable auditing on a
spreadsheet. So I either have to get it not to show up in the list or I have
to run the uninstall only for admin users.

Thanks,
Ryan

 

[Bill Renaud]

<<I'd like to have the audit addin enabled, but not show up in the
available addins list because I don't want the user to disable auditing on
a spreadsheet.>>

OK, I think I understand your problem now. I don't know if this is possible
or not. You might have to check the Knowledge Base (KB) on the Microsoft
web site.

I use Excel 2000, so maybe things are different on my machine. Do you mean
the Auditing Toolbar, which has buttons to show Precedents, Dependents and
Circle Invalid Data (circular references)? In Excel 2000, the Auditing
Toolbar is built-in, so it cannot be removed. It is not an add-in.