Solve the Problem of entering spaces in the Excel VBA editor and returning them automatically

Today, I used the Excel VBA editor to modifyCodeWhen it is found that the input space will be automatically returned, and the input & and quotation marks will also be automatically escaped, almost unable to write code normally. Follow these steps to solve the problem:

1. Find the developer menu in Excel. If the developer menu is not displayed, click File-options-Customize ribbon and select developer in main tabs on the right.

2. Click COM add-ins. In the displayed dialog box, remove Load Test Report addin.

This problem may be caused by the installation of Visual Studio 11 on the machine.ProgramIs an external program added for excel2010 by visual studio11 to create a test report. When you try to remove Load Test Report addin from the COM add-ins window, the system administrator will prompt that the file cannot be deleted. Find the Excel installation directory, such as c: \ Program Files (x86) \ Microsoft Office \ office14. click excel.exe on the right, select Run as administrator, and delete the file. In addition, click File-options-add ins in Excel. The list shows the names, locations, and types of all external programs. Here you can learn more about the external programs.