MSI installed add-in for all terminal server users, how do I configure it just for one user?

Invantive Control and other Office add-ins are installed as an add-in to Excel and other Office products. By default, the installation is done for all users of a device.

When running on a terminal server, you might want to disable the add-in for most users and activate for specific users.

How do you configure the add-in to be available only for specific users?

Instructions

This instruction is just provided as a suggestion. The procedure, possible damages and configuration on non-vanilla terminal server installations are not covered by a subscription.

Please consult your local system administrator for expertise or contact Invantive or dealers for consulting on basis of Time & Material.

This answer provides a solution that involves changing the registry. Please make sure you have a recoverable backup in case you might break anything.

Already using another add-in?

The steps to selectively enable Visual Studio Tools for Office (“VSTO”) add-ins on a terminal server is typically identical across all Invantive and non-Invantive add-ins.

Please first consider use of a working procedure you already have grown accustomed to for other VSTO add-ins supplied by 3rd parties.

Steps

Perform the following steps:

  1. Click the Windows icon and type regedit.exe.
  2. Navigate to HKEY_LOCAL_MACHINE\Software\Microsoft\Office\Excel\Addins\Invantive Control for Excel.
  3. Export the key using the File menu.
  4. Save the file on your desktop.
  5. Change the value of the LoadBehavior key in the registry to 0. This will disable the add-in for all users.
  6. Open the file you just saved in notepad.
  7. Change HKEY_LOCAL_MACHINE in HKEY_CURRENT_USER.
  8. Distribute this file to the user that needs to have the add-in enabled.
  9. Log in as the user that needs to have the add-in enabled.
  10. From that user account, run the registry file you have edited in the previous step by double-clicking it.
  11. Log out.
  12. Login in again.
  13. The add-in should load for users that have the registry file installed.