April 2006
Beginner
1114 pages
98h 16m
English
workbook.ProtectStructure
Returns True if the order of the sheets in the workbook is protected, False if not. The following code displays the workbook’s protection settings in the Immediate window:
Set wb = ThisWorkbook
Debug.Print "Structure protected? " & wb.ProtectStructure, _
"Windows protected? " & wb.ProtectWindowsRead now
Unlock full access