HKEY_LOCAL_MACHINE (to register the COM component to all the users of the Require admin rights because they write registry entries in the HKEY_CURRENT_USER\Software\Microsoft\VBA\VBE\6.0\Addins64\MyVBAAddin.ConnectĬOM-registration is normally achieved with some tool like regsrv32.exe forĬOM-dlls and regasm.exe for. HKEY_CURRENT_USER\Software\Microsoft\VBA\VBE\6.0\Addins\MyVBAAddin.ConnectĪnd for Microsoft Office 64-bit the registry entries would be: Language: Text So, for Microsoft Office 32-bit the registry entries would be: Language: Text This is the value to load the add-in on startup The following values must be created: Name
This means that a setup can not install an add-in for all the HKEY_LOCAL_MACHINE hive is ignored by the VBA editor when looking for add-ins). User (using the HKEY_CURRENT_USER hive), not for all users (the Important: Notice that add-ins are registered for the current HKEY_CURRENT_USER\Software\Microsoft\VBA\VBE\6.0\Addins64
To register an add-in for the VBA editor of Microsoft Office, a registry key Registration as add-in for the VBA editor Register the dll as add-in for the VBA editor.ġ.The VBA editor of Microsoft Office supports COM-based add-ins, so to register aĭll as an add-in for such host two registrations are required: NET Framework for the VBA editor of Microsoft Office for the current user without This article explains the Windows Registry entries required to register anĪdd-in created with the. INFO: Registry entries to register an add-in for the VBA editor of Office for the current user without admin rights.