Syntax

expression.ExclusiveAccess

expression A variable that represents a Workbook object.

Return Value
Boolean

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 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.

Visual Basic for Applications 
If ActiveWorkbook.MultiUserEditing Then ActiveWorkbook.ExclusiveAccess End If
Allow only one user on spreadsheet? exclusive exclusive access Exclusive Access Method exclusiveaccess ExclusiveAccess Method Prevent multiple users from editing application? Restrict the use of shared workbook?

See also: