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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()