Workbook.MultiUserEditing Property

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.

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

See also:

• Workbook Object
• Workbook Object Members
• AutoUpdateFrequency Property
• ExclusiveAccess Method
• PersonalViewListSettings Property
• PersonalViewPrintSettings Property
• ShowConflictHistory Property
• UserStatus Property