在excel中跨多个工作表锁定相同的单元格?

I have multiple sheets, with the same cells and formats etc.

我有多个表单，有相同的单元格和格式等等。

Is it possible to lock the same cells within each worksheet in the workbook? I am hoping this is possible via VBA. I know I can do this manually for each sheet, but I've got around 50 sheets.

是否可能在工作簿中的每个工作表中锁定相同的单元格?我希望这能通过VBA实现。我知道我可以为每一页手工操作，但我有大约50页。

Thanks for your help.

谢谢你的帮助。

1 个解决方案

#1

Check this out:

看看这个:

http://software-solutions-online.com/excel-vba-formating-cells-and-ranges/

You can create a macro with this tutorial for formatting and call it from your vba code.

您可以使用本教程创建一个用于格式化的宏，并从vba代码中调用它。

If it helps I would be happy about an mark :)

如果有帮助的话，我会为马克而高兴:)

#1