ExclusiveAccess Method
TOC
Collapse the table of content
Expand the table of content

Workbook.ExclusiveAccess Method (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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:
© 2016 Microsoft