Assigns the current user exclusive access to the workbook that's open as a shared list.
expression.ExclusiveAccess
expression Required. An expression that returns a Workbook object.
Remarks
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.
Example
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