Export (0) Print
Expand All
Expand Minimize

Workbook.MultiUserEditing Property

Office 2007
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.

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



Community Additions

ADD
Show:
© 2015 Microsoft