Export (0) Print
Expand All

Workbook.ExclusiveAccess Method (Excel)

Assigns the current user exclusive access to the workbook that's open as a shared list.

expression .ExclusiveAccess

expression A variable that represents a Workbook object.

Return Value

Boolean

The ExclusiveAccess method saves any changes you've made to the workbook and requires other users who have the workbook open to save their changes to a different file.

If the specified workbook isn't open as a shared list, this method fails. To determine whether a workbook is open as a shared list, use the MultiUserEditing property.

This example determines whether the active workbook is open as a shared list. If it is, the example gives the current user exclusive access.

If ActiveWorkbook.MultiUserEditing Then 
 ActiveWorkbook.ExclusiveAccess 
End If
Show:
© 2015 Microsoft