Determining a worksheet's protection status in VBA

[GeorgeJ]

What would be the syntax for finding out protection status of

activeworkbook.sheets("MySheet")

in VBA ?

 

[Jim Thomlinson]

MsgBox ActiveWorkbook.Sheets("Sheet1").ProtectContents

 

[GeorgeJ]

Thanks Jim, that was just what I needed.


-regards