Applies To
Workbook Object.
Description
True if the workbook is open as a shared list. This property is available only in Microsoft Excel for Windows 95. Read-only.
Remarks
To save a workbook as a shared list, use the SaveAs method. To change the workbook from shared mode to exclusive mode, use the ExclusiveAccess method.
See Also
ExclusiveAccess Method, SaveAs Method, UserStatus Property.
Example
This example determines whether the active workbook is open as a shared list. If it is, the example notifies the user that the macros in the active workbook cannot be modified.
If ActiveWorkbook.MultiUserEditing Then MsgBox "Cannot modify Visual Basic modules in this workbook." End If
This example determines whether the active workbook is open in exclusive mode. If it is, the example saves it as a shared list.
If Not ActiveWorkbook.MultiUserEditing Then ActiveWorkbook.SaveAs accessMode := xlShared End If