Workbook.WriteReserved property (Excel)
True if the workbook is write-reserved. Read-only Boolean.
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
Support and feedback
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.