Excel,我们发现了一些内容的问题...... [英] Excel, we found a problem with some content ...
问题描述
我制作了一个excel文件并制作了一些正常工作的宏。
I made an excel file and made some macro's which are working as they should.
当我插入一个"按钮"时为了激活宏,我保存文件,关闭它并重新打开,一切正常。
When I then insert a "button" to activate the macro, I save the file, close it and re-open, everything is ok.
但是当我然后"按"时"按钮"这样就可以激活宏(并按照自己的意愿运行)。 如果我然后保存,关闭文件并打开它,我收到消息"我们发现"...."中的某些内容存在问题。您是否希望我们以
尝试尽可能多地恢复?如果您信任工作簿的来源,请单击是。
But when I then "press" the "button" so that the macro is activated (and works as he should). If I then save, close the file and open it, I get the message " We found a problem with some content in '....' Do you want us to try to recover as much as we can? If you trust the source of the workbook, click yes.
然后我得到:
修复部分:/xl/worksheets/sheet2.xml部分。
Repaired Part: /xl/worksheets/sheet2.xml part.
然后一切看起来很正常,但是我的"按钮"已不存在了。
Then everything seems quite normal, but my "button" is not there anymore.
我的宏中的文字如下所示。 我在互联网上发现其他一些评论可能与"字符串"有关,但我只是从这个问题开始,并且不知道我应该做什么。 有人可以帮忙吗?
The text in my macro is as below. I found in some other comments on the internet that it could have to do with the "String", but I am only starting in this matter and have no idea what I should do. Somebody can help?
推荐答案
b
我'检查了你的代码,发现了一个变量"v"的
(1)。未定义
(2)此处发生运行时错误:
请说明您的代码在哪里(我猜测它在[buton]中并且提供没有运行时错误的代码。
或者通过Dropbox,OneDrive等云存储共享你的文件,以便我们识别你的问题。
问候,
Hi,
I've checked your code, and found
(1) a variable "v" is not defined
(2) run-time error occurs here:
Please specify where is your code (I guess it is in a [buton]) and provide code without run-time error.
Or share your file via cloud storage such as Dropbox, OneDrive, etc. in order for us to identify your issue.
Regards,
这篇关于Excel,我们发现了一些内容的问题......的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!