MultiUserEditing Property

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