Geek Answers Handbook

How to disable automatic backspace in Excel VBA Editor

When typing in the editor, it returns me to the end of the last word.

For example, I want Sub Entername()

If I'm not SubEnterName() fast enough, it goes: SubEnterName() .

How do I turn this off.

+7
source share
5 answers

I have heard about this problem before. Follow these steps:

  • Close the limit.
  • First, open it in safe mode (type "excel.exe / s" in the launch box).
  • Open the VBA editor and try to write a macro. Problem should not arise
  • Close the upper limit and open it again.

I heard that these steps fixed this problem earlier for others.

+8
source

Are you using any VBE add-ons such as Smart Indenter or Code Cleaner? Uninstall Code Cleaner and install it only when you are going to use it, then uninstall it when done. I had the same problem and Code Cleaner was the culprit. I believe that this may be due to two of them.

For reference:

+1
source

This issue is related to a COM add-in called Add Load Add Report. to disable it, follow these steps: go to Excel Options → Add-Ins and select Excel COM Add-ins from bottom to bottom and click Go... then uncheck the box next to “Add test report” to change it. this will fix the problem!

+1
source

To prevent automatic updates and deletion of backups in the VBA editor, you must make sure that all forms or reports with On-Timer event procedures are in design mode or that the code should be disabled (i.e. converted to comments).

However, it is better to make sure that all forms and reports are in design mode, which means that none of the On-Timer codes are executed.

Hope this helps.

Shafiu.

0
source

Is autosaving enabled? I had a file doing this just now. While typing SOON, when I stopped, autosave worked - (by accident, I'm sure) it caused VBE to kill spaces.

Did two tests: -Moved file with Sharepoint on my local machine, worked fine -Turned with AutoSave on a copy of Sharepoint, worked fine

0
source

More articles:


All Articles