We have a Sharepoint-like system in place and when users try to open an Excel 2010 file in it, it errors out due to an excel add-in we also have in place. Both are integral parts of our operation and until I can get these two vendors together to resolve the problem, I would like to write a quick ittle VB program that toggles the option in Excel that disbales all Add-ins in Excel. The drill down to disable add-ins can be a little to much for some of our basic users and I'd just like for them to click a button.

The option in Excel I'd like to toggle is Excel 2010>File>Options>Trust Center> Trust Center Settings>Add-Ins>Disable all Application Add-ins. Where can I find the registry entry for this option in Windows 7 (64-bit)?

Hi

There is no registry entry that directly used to disable excel add-ins, you might need to manually create it.

See to the link below to learn more about Excel COM add-ins and Automation add-ins:

http://support.microsoft.com/kb/291392

Here is a thread on how to enable an Excel automation add-in for your reference:

http://stackoverflow.com/questions/6309584/how-do-i-enable-an-excel-automation-add-in-through-the-registry

(Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.)

Regards

Tylor Wang
TechNet Community Support