Determine if a sheet is protected?

[Robert Crandal]

How can I determine if a sheet is protected or not?

thank u

 

[Bob Phillips]

Try

activesheet.protectcontents

HTH

Bob

 

[Gord Dibben]

Sub test()

MsgBox ActiveSheet.ProtectionMode 'returns true or false

End Sub


Gord Dibben MS Excel MVP

 

[Libby]

Hi Robert,

Sheet1.ProtectContents

True = protected, False = unprotected.

 

[Dave Peterson]

With worksheets("SomeSheetNameHere")
If .ProtectContents = True _
Or .ProtectDrawingObjects = True _
Or .ProtectScenarios = True Then
'it's protected
else
'it's not protected
End with