April 2006
Beginner
1114 pages
98h 16m
English
worksheet.Protection
Returns a Protection object that represents the protection attributes of the worksheet.
The following code displays a message if you can’t delete rows in a worksheet:
If ActiveSheet.Protection.AllowDeletingRows = False Then
MsgBox "Sorry, you can't delete this row."
End IfRead now
Unlock full access