Excel.Workbook.MultiUserEditing.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Workbook.MultiUserEditing property (Excel)	vbaxl10.chm199113	vbaxl10.chm199113	Excel.Workbook.MultiUserEditing	dc721463-ec34-8c52-6701-51c406beed23	05/29/2019	medium

Workbook.MultiUserEditing property (Excel)

True if the workbook is open as a shared list. Read-only Boolean.

Syntax

expression.MultiUserEditing

expression A variable that represents a Workbook object.

Remarks

To save a workbook as a shared list, use the SaveAs method. To switch the workbook from shared mode to exclusive mode, use the ExclusiveAccess method.

Example

This example determines whether the active workbook is open in exclusive mode. If it is, the example saves the workbook as a shared list.

If Not ActiveWorkbook.MultiUserEditing Then 
 ActiveWorkbook.SaveAs fileName:=ActiveWorkbook.FullName, _ 
 accessMode:=xlShared 
End If

[!includeSupport and feedback]