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.
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
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.