Workbook.WriteReserved property (Excel)
True if the workbook is write-reserved. Read-only Boolean.
expression.WriteReserved
expression A variable that represents a Workbook object.
Use the SaveAs method to set this property.
If the active workbook is write-reserved, this example displays a message that contains the name of the user who saved the workbook as write-reserved.
With ActiveWorkbook
If .WriteReserved = True Then
MsgBox "Please contact " & .WriteReservedBy & Chr(13) & _
" if you need to insert data in this workbook."
End If
End With
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.