April 2006
Beginner
1114 pages
98h 16m
English
workbook.WriteReserved
Returns True if the workbook has a WritePassword; otherwise, returns False. This property is similar to the HasPassword property, only it checks for a write password. The following code checks if the workbook has a write password and displays the name of the person who set the write password if it does:
Set wb = ThisWorkbook
If wb.WriteReserved Then _
Debug.Print "Reserved by: " & wb.WriteReservedByRead now
Unlock full access