The VBA ide displays a project that is not open. The solution cannot be operated

Time:2022-1-8
Reading time |0.24 minutes word count |388 characters
primary coverage |1. Introduction & background
“VBA ide displays the project that is not open, and the solution cannot be operated”
Author | SCscHero Writing time | 2021/12/29 PM7:28
Article type |Series Degree of completion |Completed
motto Every great cause has a trivial beginning.

1、 Introduction & backgroundCompletion: 100%


a) Dealing with problems

Put the normal on your PC these days The dotm file wants to be transferred to the company computer for use. Some written macros can be used directly, so the normal The dotm file directly replaces the normal The dotm file causes the following problems:

  1. The macro could not be created, as shown in the figure.
The VBA ide displays a project that is not open. The solution cannot be operated
  1. The VBA ide that comes with office cannot be used.Display: there are no open projects.And the menu is inoperable. It’s all gray.
The VBA ide displays a project that is not open. The solution cannot be operated

b) Application scenario

  • Common in misoperation of normal When the dotm file is, it causes a series of abnormal reactions.

2、 SolutionCompletion: 100%


  1. When the above situation occurs, it indicates that an error operation has occurred. Therefore, remove the template file referenced by the machine first, which can be found in the following address.
C: \ users \ Windows user name \ appdata \ roaming \ Microsoft \ templates

[note] replace the windows user name.

  1. After removal, reopen word, observe whether the VBA IDE is reset, and then press the import method in the next chapter to import.

3、 Extension: import dotm files correctlyCompletion: 100%


Take word as an example, find the developer tab, select document template, and select normal for backup in add Dotm file.

The VBA ide displays a project that is not open. The solution cannot be operated

4、 Statements and referencesCompletion: 100%


Original blog post, please do not reprint without permission.

If you are helpful, you are welcome to like, collect and pay attention. If you have any questions, please comment! If you need to contact the blogger, you can write scschero directly.

Recommended Today

The whole tutorial of docker installation and use, installation / complete command / dockerfile image production / docker container arrangement and one click installation of nginx + redis + MySQL / visualizer portal (version 2022)

官网: https://docs.docker.com/ 官网: https://www.docker.com/ docker 镜像市场: https://hub.docker.com/ 一、docker 说明 1.1、docker 核心 1、Docker 是一个开源的应用容器引擎,基于 Go 语言 并遵从 Apache2.0 协议开源,Docker 是一个 CS 架构软件。 2、Docker 是一个虚拟化轻量级linux服务器,可以解决我们在开发环境中运行配置问题 3.、Docker的主要目标是‘build ,ship and run any app,anywhere’,一次封装,到处运行 4、容器是完全使用沙箱机制,相互之间不会有任何接口(类似 iPhone 的 app),更重要的是容器性能开销极低。 1.2、docker 版本问题 .Docker 从 17.03 版本之后分为 CE(Community Edition: 社区版) 和 EE(Enterprise Edition: 企业版),我们用社区版就可以了。 1.3、docker 架构( 3大核心) · 1、Images 镜像 (等于软件) · 2、Registry […]