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屋！