多半是VBA少了某个控件。所以要先检查一下缺少什么控件。link
I noticed some similar cases related to the .OCX file missing. You may try the following steps:
1.Open the spreadsheet
2. Open the developer console with ALT-F11
3. Open Tools -> References
4. Note the names and file locations of any controls that are marked MISSING
我的是因为缺少MSCOMCTL2.OCX(注意是版本2!!!)
解决方法:去谷歌下载MSCOMCTL2.OCX,放到 “C:\Windows\SysWOW64” 里面; link