How to tell if worksheet is protected?

Posted by EJM on January 03, 2001 9:21 AM

Is there a way to tell if a worksheet is currently protected?
I need to change a value of a cell based on whether or or not the sheet is protected.

Thanks

Posted by Dave on January 04, 2001 12:13 AM

Hi EJM

This code will tell you if cell protection is on

Sub ProtectedOrNot()
If Sheet1.ProtectContents Then
'&LT;Your Code>
End If
End Sub