close
Is it possible when looping through the Sheets in a Workbook to check the
Protection Status of each sheet?
Thanks
Andy Williams
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.
quot;Andy Williamsquot; wrote:
gt; Is it possible when looping through the Sheets in a Workbook to check the
gt; Protection Status of each sheet?
gt;
gt; Thanks
gt;
gt; Andy Williams
全站熱搜