Determine if a sheet is protected?
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
|