Applies To
Workbook Object.
Description
Assigns the current user exclusive access to the workbook that's open as a shared list. Returns True if the workbook is successfully made an exclusive, nonshared list. This method is available only in Microsoft Excel for Windows 95.
Syntax
object.ExclusiveAccess
object
Required. The 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 changes to a different file.
If the specified workbook isn't open as a shared list, ExclusiveAccess fails. To determine whether a workbook is open as a shared list, use the MultiUserEditing property.
See Also
MultiUserEditing Property, SaveAs Method.
Example
This example determines whether the active workbook is open as a shared list. If it is, the example assigns the current user exclusive access.
If ActiveWorkbook.MultiUserEditing Then
ActiveWorkbook.ExclusiveAccess
End If