用户窗体工具箱附加控件对话框窗口未显示 [英] Userform toolbox additional controls dialogue window not showing
问题描述
虽然使用MS Excel(显然还有Outlook，Word或Power Point)，但我创建了一个用户表单.工具箱出现，显示控件"选项卡和代表各种控件的16个图标.当我右键单击工具箱控件区域中的某个空白区域时，将出现一个菜单，在顶部列出其他控件"，并在其下方列出两个灰色的选项.当我选择其他控件"时，一个旋转的蓝色圆圈短暂出现，然后消失，什么也没有发生.
While using MS Excel (Outlook, Word, or Power Point as well apparently) I create a userform. The toolbox shows up showing controls tab and 16 icons representing various controls. When I right click in some empty space in the tool box control area, a menu comes up listing "additional controls" at the top and two greyed out options below it. When I select "additional controls" a spinning blue circle appears briefly then disappears and nothing happens.
据我了解，此时应打开一个对话框，我应该能够选择一些其他控件.
It is my understanding that a dialogue box should open at this point and I should be able to select some additional controls.
我在尝试观看有关如何为我的个人项目进行数据抓取的视频时注意到了问题，该视频我寻求帮助
I noticed the problem while trying to follow a video on how to data scrape for my personal project which I asked for help here.
在另一台计算机上创建用户表单，然后将其导入到该计算机中.没有成功.
Creating a user form on another computer and then importing it to this one. No success.
修复MS Excel.我相信这完全重新安装了，因为我必须重新输入产品密钥.没有成功.
Repairing MS Excel. This resulted in a full reinstall I believe as I had to re enter my product key. No success.
按此文章.没有成功.
KB 369383 作为上述过程的一部分.没有成功.
KB 369383 as mention as part of the process above. No success.
问题在此处中进行了描述，但没有解决方案，只是解决该人要添加的内容.
Issue described here but no solution, just a work around to something to what the person was trying to add.
将MS Excel设置为在兼容模式下运行.在桌面图标的属性下，没有列出兼容模式作为选项.
Setting MS Excel to run in compatibility mode. There was no compatibility mode listed as an option under properties for the desktop icon.
即使我的Windows帐户具有管理员权限，也要以管理员身份运行.没变化.
Running as administrator even though my Windows account has admin rights. No change.
使用ccleaner和明智的注册表清理器来清理注册表.
Cleaning the registry with both ccleaner and wise registry cleaner.
使用excel.exe/s以安全模式运行Excel.在标题栏中以(安全模式)确认.没有成功.
Running Excel in safe mode using excel.exe /s. Confirmed with (safe mode) in the title bar. No success.
Windows 10
Windows 10
MS Office Professional 2013-32
MS Office Professional 2013 - 32
(注意，我知道没有添加水晶报告)
(Note, no crystal reports added that I am aware of)
我尝试了另一台运行相同版本MS Office的Windows 10计算机，并且该计算机在该计算机上运行，因此它不应该仅仅是Windows 10问题.我的机器是Windows 7-64的升级.另一台机器是Windows 8的升级.
I tried another Windows 10 machine running same version of MS Office and it worked there, so it should not solely be a Windows 10 issue. My machine was an upgrade from Windows 7 - 64. The other machine was an upgrade from windows 8.
我创建了一个新的Windows用户帐户，并出现了该帐户的对话框.至少现在我们知道它与我的用户帐户/个人资料有关.
I created a new Windows user account and the dialogue box comes up for that account. At least now we know that its SOMETHING to do with my user account/profile.
推荐答案
我花了2-3晚的时间找到了解决我的"问题的解决方案.事实证明这是一个非常简单且不太直观的解决方案.
I found a solution to 'my' problem after spending 2-3 nights over this. It turned out to be a very simple and not-so-intuitive fix.
我的问题是，当我右键单击工具箱"时，我什至没有看到菜单中的其他控件"选项.
My problem was that when I right-click on the Toolbox, I do not even get to see the "Additional Control" option in the menu.
单击用户窗体，使其处于选中状态. 现在转到工具和其他控件"不再显示为灰色. :)
Click on the userform, so that its selected. Now go to Tools and Additional Controls is no longer greyed out. :)
这篇关于用户窗体工具箱附加控件对话框窗口未显示的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
