Skip to content

Excel.Workbook.WriteReservedBy.md

Latest commit

 

History

History
41 lines (27 loc) · 972 Bytes

Excel.Workbook.WriteReservedBy.md

File metadata and controls

41 lines (27 loc) · 972 Bytes
title Workbook.WriteReservedBy property (Excel)
keywords vbaxl10.chm199168
f1_keywords
vbaxl10.chm199168
api_name
Excel.Workbook.WriteReservedBy
ms.assetid f053c197-3af3-9ab7-bee1-f72ee311a5b8
ms.date 05/29/2019
ms.localizationpriority medium

Workbook.WriteReservedBy property (Excel)

Returns the name of the user who currently has write permission for the workbook. Read-only String.

Syntax

expression.WriteReservedBy

expression A variable that represents a Workbook object.

Example

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

[!includeSupport and feedback]