Sheet Protection Status

A

Andy Williams

Is it possible when looping through the Sheets in a Workbook to check the
Protection Status of each sheet?

Thanks

Andy Williams
 
W

William Horton

There are 3 properties for Worksheet protection that you can check to see if
they are turned on or off. They are:

.ProtectContents
.ProtectDrawingObjects
.ProtectScenarios
 
Top