Protection Object

Represents the group of sheet protection options. When you protect a sheet, you now have the option to only allow unlocked cells selected, allow cell, column, and row formatting, allow insertion and deletion of rows and columns, allow sorting, and more.

Setting Protection options is done via the Protect method of the Worksheet object. Use the Protection property of the Worksheet object to check the current protection settings:

MsgBox ActiveSheet.Protection.AllowFormattingCells

0 0

Post a comment