Excel 2007 Visual Basic编辑器：使用空格，抛出光标 [英] Excel 2007 Visual Basic Editor: eats spaces, throws cursor around

问题描述

我无法解决此问题，我发现一个类似的问题这里，但是：

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

• 将工作簿设置为手动计算（alt-mxm或alt-to>公式）没有工作


• 设置编辑器选项以禁用：自动语法检查&后台编译不起作用

任何人都有任何想法如何解决这个非常讨厌的行为，我习惯于快速弹出VBA （alt-f11），f7进入代码并写一些快速的程序，很难摆脱这种习惯，我不想写任何办公室扩展，只需要添加一个单引号到每个单元格范围

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，完成...

推荐答案

我有这个确切的问题，以下对我有用。

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

1.点击Microsoft Office按钮，然后单击Excel选项

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

2.单击加载项类别

3.在管理框，单击COM加载项，然后单击Go。

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

4.查找名为加载测试报告AddIn的添加，然后取消选中

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

5.restart excel

5.restart excel

此插件与VS2010 Beta2一起安装

This addin is installed with VS2010 Beta2

这篇关于Excel 2007 Visual Basic编辑器：使用空格，抛出光标的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！