复制粘贴（VBA）

本文介绍了复制粘贴（VBA）的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

嗨朋友们，

我们在WorkBook中有三张表。

现在我在SHEET1中选择要复制的数据。所以现在SHEET1在CopyMode中。现在选择SHEET3并保护SHEET3。

然后选择SHEET1并尝试粘贴数据。它不会粘贴数据。

因此当我执行Protect或Unprotect等操作时。它清除复制的数据。

所以我不明白这些是功能还是错误。并且你能告诉我怎么解决它？

谢谢

解决方案

这听起来像是一个愚蠢的答案，但为什么不在选择要从sheet1复制的内容之前取消保护sheet3。复制完成后再次保护sheet3。 （或者看看设置保护时设置的属性，调整它们，你可以粘贴而不做我的建议）

ChasAA

Hi Friends,

We have three sheets in WorkBook.

Now I selects Data to Copy in SHEET1. So Now SHEET1 is in CopyMode. Now Select SHEET3 and PROTECT the SHEET3.

and then Select SHEET1 and Try to Paste the data. it will not paste the data.

So when I do the Operation like Protect or Unprotect. It Clears the Copied data.

So I m not understanding these is Feature or Bug. and Can U tell me How can solve it???

 

Thanks

 

解决方案

This might sound like a silly answer, but why not unprotect sheet3 before selecting what to copy from sheet1.  After the copy is complete then protect sheet3 again.  (Or have a look at the attributes that are set when the protection was set, adjust them and you may be able to paste without doing what I suggested)

ChasAA