xlDialogOpen
---------------
file_text, update_links, read_only, format, prot_pwd, write_res_pwd,
ignore_rorec, file_origin, custom_delimit, add_logical, editable,
file_access, notify_logical, converter

More generally: for all dialogs
-----------------------------------
type Application.Dialogs, then select 'Dialogs' and press F1 to get the
Help. There, click the 'Dialogs' link and finally on that page you have a
"see Built-in Dialog Box Argument Lists." link for all Dialogs.

Option.
---------
You can use the other dialog to open files. I personally prefer it:
Application.FileDialog(msoFileDialogOpen)
Check the help for more details.

--
Regards,
Sébastien
<http://www.ondemandanalysis.com


"frice" wrote:

I am trying to display the file Open dialog such that when the user selects
the particular file, it is automatically opened as Read-Only. I'm using:

Application.Dialogs.Item(xlDialogOpen).Show Arg1:="Book1.xlsm", Arg3:=True

Arg1 works so that only Book1.xlsm is shown but when I open the file, it is
not opened as read-only. Any ideas of what I'm doing wrong?

Thanks