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

Winword VBA IDE works fine, so it's only in Excel for the moment.

I have tried re-installing, I have tried the Excel options > Resources > diagnostic tool which reported that it fixed 1 issue but the problem remained.

The problem effectively seems to be that the Visual Basic Editor compiles every second (or less) and removes spaces.

An ugly work around is to put a single quote after your cursor and it won't remove the spaces, but that's just silly.

I'm currently waiting for the Office 2007 Enterprise "Change" > "Repair" to finish & test it again, else I'm going to stick with the single quote.

Answer 2

I've hit this issue too, and for me it was related to an Excel add-in which would explain why you're not seeing it in the Word VBE. Try going into the trust center and disabling all application add-ins - if that fixes it, then you can work out which is going wrong by a process of elimination. In my case, it was the Load Test Report Addin which installs with VS2010 beta 2.

Answer 3

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