Workbook.MultiUserEditing Property (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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

expression .MultiUserEditing

expression A variable that represents a Workbook object.

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.

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
Show: