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

thank u

Try

activesheet.protectcontents

HTH

Bob

"Robert Crandal" <(E-Mail Removed)> wrote in message
news:h865n.9557$(E-Mail Removed)...
> 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" <(E-Mail Removed)>
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