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

thank u

Try

activesheet.protectcontents

HTH

Bob

"Robert Crandal" wrote in message
...
How can I determine if a sheet is protected or not?

thank u

Sub test()

MsgBox ActiveSheet.ProtectionMode 'returns true or false

End Sub


Gord Dibben MS Excel MVP

On Mon, 18 Jan 2010 16:28:18 -0700, "Robert Crandal"
wrote:

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

thank u

Hi Robert,

Sheet1.ProtectContents

True = protected, False = unprotected.


"Robert Crandal" wrote:

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

thank u


.

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