Excel CommandButton名称更改 [英] Excel CommandButton names changing

问题描述

我在 ActiveX-CommandButtons 上使用宏创建了一个excel文件.当我刚完成它们时，它们工作得很好.再次打开文件后，命令按钮名称更改.

I created an excel file with macros on ActiveX-CommandButtons. They worked well, when I just finished them. As soon as I opened the file again, the CommandButton-Names changed.

例如:

CommandButton1更改为CommandButton2

CommandButton1 changed to CommandButton2

CommandButton2更改为CommandButton3等

CommandButton2 changed to CommandButton3 etc.

我没有在reasearch中找到任何东西，这是一个excel错误还是只是您可以更改首选项的内容?

I didn't found anything in my reasearch, so is this an excel bug or just something that you can change in your preferences?

推荐答案

右键单击CommandButton

Right click on CommandButton

转到(单击)设置文本效果的格式"

Go to (click on) 'Format Text Effects'

将名称提供给按钮，随便哪个.

Give the name to button, whichever you want.

保存.

关闭工作簿.

重新打开并检查名称是否更改

Open it back and check whether name changes

(无需启用设计模式")

(No need to enable 'Design Mode')

对我有用.希望它也对您有用.

It works for me. Hope it shall work for you too.

如果它不起作用，请告诉我.

If it do not work then please let me know.

有关更多信息: 查看全文