Workbook.ChangeFileAccess (Excel)

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

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.

ChangeFileAccess (Mode, WritePassword, Notify)

ActiveWorkbook.ChangeFileAccess Mode:=xlReadOnly

Arguments

The following argument is required

Mode (XlFileAccess) - Specifies the new access mode.

Possible return values are xlReadOnly - Read-only, xlReadWrite - Read/write.

Optional arguments

The following arguments are optional

WritePassword (XlFileAccess) - 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.

Possible return values are xlReadOnly - Read-only, xlReadWrite - Read/write.

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