Excel 2007 Visual Basic Editor: eats spaces, throws cursor around

Question

I can't resolve this issue, I found a similar question here but:

• setting the workbook to Manual calculation (alt-m-x-m or alt-t-o>formulas) didn't work
• Setting editor options to disable: Auto syntax check & Background compile didn't work

anybody have any idea how to fix this very annoying behaviour, I'm used to quickly pop up VBA (alt-f11), f7 to get into code and write some quick procedures there... and it's hard to get out of that habit, I don't want to write any office extension to just add a single quote to every cell in the range

For Each rg In Selection
  rg = chr(39) & rg.value
Next

F5, done...

Answer 1

I had this exact problem and the following worked for me.

1.Click the Microsoft Office Button, and then click Excel Options

2.Click the Add-Ins category

3.In the Manage box, click COM Add-ins, and then click Go.

4.Look for an add in called 'Load Test Report AddIn' then uncheck it

5.restart excel

This addin is installed with VS2010 Beta2

Answer 2

I'm using excel 2010 and face similar problem. When I hit space bar, editor removes the space and put cursor to end of last character. Tried unchecking add-in coms without resolution.

"In Excel 2010, toggling Design Mode button on the Developer Ribbon Tab solves the problem for me."

Or in vba editor, CLICK on Design Mode button (icon with pencil) to enter design mode. From the Run menu, select "Design Mode".

Got it from this link:

https://social.msdn.microsoft.com/Forums/office/en-US/3353f2d3-7e92-424b-934c-0eedd21b9a90/excel-2010-vb-editor-auto-deleting-spaces?forum=exceldev