ExcelBanter - testing if a sheet is protected

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

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

- - testing if a sheet is protected (https://www.excelbanter.com/excel-programming/276508-re-testing-if-sheet-protected.html)

John Wilson

testing if a sheet is protected

mika,

worksheets("Main").protectcontents
Should return True or False

John

"mika." wrote:

How would you test if a worksheet is protected using VBA?

Thanks.

All times are GMT +1. The time now is 12:43 PM.