Workbook.MultiUserEditing property (Excel)
True if the workbook is open as a shared list. Read-only Boolean.
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
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.