ExcelBanter - Is worksheet protected?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Is worksheet protected? (https://www.excelbanter.com/excel-programming/303905-worksheet-protected.html)

Kolmyk AE

Is worksheet protected?

How to detect (VBA) is worksheet protected or it is not?

Thank you.

Frank Kabel

Is worksheet protected?

Hi
try
If Worksheets("Sheet1").ProtectContents Then
MsgBox "Sheet1 is protected."
End If

--
Regards
Frank Kabel
Frankfurt, Germany

Kolmyk AE wrote:
How to detect (VBA) is worksheet protected or it is not?

Thank you.

All times are GMT +1. The time now is 03:42 AM.