VBA editor auto-deletes spaces at the ends of lines
I had this exact problem and the following worked for me.
- Click the Microsoft Office Button, and then click Excel Options
- Click the Add-Ins category
- In the Manage box, click COM Add-ins, and then click Go.
- Look for an add in called 'Load Test Report AddIn' then uncheck it
- restart excel
This addin is installed with VS2010 Beta2
I've definitely had that issue before, where the vba editor would format as I was typing (not just when I went to another line). For me, it seemed to be related to a Microsoft Web Browser control that I had in an open workbook. When I took out the web browser, the VBA editor started acting normally again. I have no idea why that worked, but it did. Now I avoid using that control in my workbooks.