如何复制保护单元格 [英] How to Copy Protect a cell

问题描述

嗨团队
我想知道如何在MS Excel 2007或2010中的特定单元格或整个工作表中复制数据?

Hi team
I`d like to know how do I copy-protect data in specific cells or the entire worksheet in MS Excel 2007 or 2010?

推荐答案

看看 http://msdn.microsoft.com/en-us/library/dkcs53f3.aspx [ ^ ].

只需记录执行该操作的宏，然后您就可以看到代码是什么.

您需要确保在格式"单元格下，保护"选项卡上该单元格被标记为锁定".然后使用所需的任何设置保护工作簿.然后，您可以进入VBA设计器并查看代码.

Just record a macro doing the action and then you can see what the code would be.

You need to make sure that under format cells the cell is marked as Locked on the Protection tab. Then protect the workbook with whatever settings you want. Then you can go into the VBA designer and see the code.

这篇关于如何复制保护单元格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！