Sheet Protection Status
 

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

Thanks

Andy Williams

Sheet Protection Status
 

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

.ProtectContents
.ProtectDrawingObjects
.ProtectScenarios

On each loop (worksheet) you can check the status of these properties.

"Andy Williams" wrote:

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

Thanks

Andy Williams