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



Robert Crandal wrote:

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

thank u

--

Dave Peterson