安装rubberduck后看不到加入? [英] Can not see the add in after installing rubberduck?
问题描述
操作系统:windows 7 pro
Excel 2007
64位
免责声明:我是Rubberduck项目的创始人之一
Rubberduck是一个VBE 加载项,而不是Excel或COM加载项;如果它正确注册为VBE加载项,那么您可以从VB中的加载项管理器从加载项菜单中找到它:
注意:避免从该窗口加载/卸载Rubberduck - 有一些已知的拆卸问题(大部分在下一个版本2.0.12中是固定的),这些问题与VBE的add-在
VBE在HKCU配置单元下查找可用的加载项,这是针对当前用户 - if你不是运行安装程序的管理员用户,VBE不知道有一个新的加载项,因为HKCU没有这样说的。
安装说明在项目的维基中:
Rubberduck安装程序需要管理权限,特别是注册启用单元测试功能的COM类型。因为VBE加载项需要在HKCU注册表配置单元下注册,所以安装程序将为运行安装程序的管理员用户创建Addins密钥。
要注册非管理员用户的加载项,您需要运行以下PowerShell命令:
Set-ExecutionPolicy -ExecutionPolicy RemoteSigned
新项目-Path'HKCU:\Software\Microsoft\VBA\VBE\6.0\AddIns64\Rubberduck.Extension' -Force
New-ItemProperty -Path'HKCU:\Software\Microsoft\VBA\VBE\6.0\AddIns64\Rubberduck.Extension'-Name描述-PropertyType String -Value'Rubberduck'
New-ItemProperty -Path'HKCU:\Software\Microsoft\VBA\VBE\6.0\AddIns64\Rubberduck.Extension'-Name FriendlyName -PropertyType String -Value'Rubberduck'
New-ItemProperty -Path'HKCU:\Software\Microsoft\VBA \\ VBE\6.0\AddIns64\Rubberduck.Extension'-Name LoadBehavior -PropertyType DWord -Value 3
这将安全地创建HKCU下所需的注册表项,VBE正在寻找其加载项: HKCU:\Software\Microsoft\VBA\VBE\6.0\AddIns64
。请注意,32位VBA主机将在 \6.0\AddIns
键下寻找加载项。
或者,您可以在注册表编辑器中手动创建缺少的键:
I am new to rubberduck and have installed the latest version 2.0.11. After admin installed, I go to excel and check my com-addins and it does now show rubberduck there. I've check my programdata folder and yes, rubberduck is there with all files ect. It is just not showing up on my add in for excel. Help?
OS: windows 7 pro Excel 2007 64bit
Disclaimer: I am one of the founders of the Rubberduck project
Rubberduck is a VBE add-in, not an Excel or COM add-in; if it's properly registered as a VBE add-in you'll find it in the VBE's Add-In Manager, from the Add-Ins menu:
note: avoid loading/unloading Rubberduck from that window - there are known teardown issues (most of which are fixed in next release 2.0.12) that don't play well with the VBE's add-in manager.
The VBE looks for available add-ins under the HKCU hive, which is for the current user - if you're not the admin user that ran the installer, the VBE doesn't know there's a new add-in because there's nothing under HKCU that says so.
Per the installing instructions in the project's wiki:
Installing for non-admin users
The Rubberduck installer requires administrative privileges, notably to register the COM types that enable the unit testing feature. Because VBE add-ins need to be registered under the HKCU registry hive, the installer will create the Addins key for the admin user that is running the installer.
To register the add-in for a non-admin user, you need to run the following PowerShell commands:
Set-ExecutionPolicy -ExecutionPolicy RemoteSigned
New-Item -Path 'HKCU:\Software\Microsoft\VBA\VBE\6.0\AddIns64\Rubberduck.Extension' -Force
New-ItemProperty -Path 'HKCU:\Software\Microsoft\VBA\VBE\6.0\AddIns64\Rubberduck.Extension' -Name Description -PropertyType String -Value 'Rubberduck'
New-ItemProperty -Path 'HKCU:\Software\Microsoft\VBA\VBE\6.0\AddIns64\Rubberduck.Extension' -Name FriendlyName -PropertyType String -Value 'Rubberduck'
New-ItemProperty -Path 'HKCU:\Software\Microsoft\VBA\VBE\6.0\AddIns64\Rubberduck.Extension' -Name LoadBehavior -PropertyType DWord -Value 3
This will safely create the required registry keys under HKCU, where the VBE is looking for its add-ins: HKCU:\Software\Microsoft\VBA\VBE\6.0\AddIns64
. Note that 32-bit VBA hosts will be looking for add-ins under the \6.0\AddIns
key.
Alternatively, you can create the missing keys manually in the registry editor:
这篇关于安装rubberduck后看不到加入?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!