Determine if a sheet is protected?

G

Gord Dibben

Sub test()

MsgBox ActiveSheet.ProtectionMode 'returns true or false

End Sub


Gord Dibben MS Excel MVP
 
D

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sheet protection complications 4
How to determine whether a protected sheet has a password? 1
Using Groups on Protected Sheets 12
How to determine if the workbook is protected? 2
Preventing "Protect Workbook" 2
quick way to prohibit all editing/changes to workbook (2010) 2
Spell Checking on a protected sheet 1
Sheet protection 1

Top