check if a worksheet is protected (XL2003NL)

Topic

New Reply

Hello all,
How could I check with VBA if a worksheet is protected?

Thanks in advance for your answer
Greetings,
Patick Schouten

Reply | Quote

Replies

Hello all,
How could I check with VBA if a worksheet is protected?

Thanks in advance for your answer
Greetings,
Patick Schouten

Hi Patrick,

For a workbook, you could try something based on:
If ThisWorkbook.ProtectStructure = True Or ThisWorkbook.ProtectWindows = True Then …

For a Worksheet, you could try something based on:
If ThisWorkbook.Worksheets(1).ProtectContents = True Then …

Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Reply | Quote

You can inspect the ProtectContents property of the sheet. From the Excel VBA help:

Code:

If Worksheets("Sheet1").ProtectContents = True Then
	MsgBox "The contents of Sheet1 are protected."
End If

Reply | Quote

Thanks,

It works.

greetings,
Patrick

Reply | Quote