Enable or Disable Excel Add-in

Help
, ,
1

Hi Guys!

I need to enable or disable a few add-in in excel, there is a way to do it without going to the long path, I mean without open excel and going to options?

I will appreciate any thoughts

2

@carmen

You could use the RegistryKey class to modify registry and control the add-ins.

Below code will enable and add-in for you.

RegistryKey myKey = Registry.CurrentUser.OpenSubKey(@"Software\Microsoft\Office\Excel\Addins\Create.ExcelAddIn", true);
if (myKey != null)
{
    myKey.SetValue("LoadBehavior", "3", RegistryValueKind.DWord);
    myKey.Close();
}
1 Like
3

ok thanks for answer … I will try it.

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.