Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

ChangeFileAccess Method [Excel 2003 VBA Language Reference]

Office 2003

Changes the access permissions for the workbook. This may require an updated version to be loaded from the disk.

expression.ChangeFileAccess(Mode, WritePassword, Notify)

expression Required. An expression that returns one of the objects in the Applies To list.

XlFileAccess can be one of these XlFileAccess constants.

WritePassword  Optional Variant. Specifies the write-reserved password if the file is write reserved and Mode is xlReadWrite. Ignored if there's no password for the file or if Mode is xlReadOnly.

Notify  Optional Variant. True (or omitted) to notify the user if the file cannot be immediately accessed.


If you have a file open in read-only mode, you don't have exclusive access to the file. If you change a file from read-only to read/write, Microsoft Excel must load a new copy of the file to ensure that no changes were made while you had the file open as read-only.


This example sets the active workbook to read-only.

ActiveWorkbook.ChangeFileAccess Mode:=xlReadOnly

Applies to | Workbook Object

© 2015 Microsoft