Read only

[Steven]

I have an excel file with a list of commonly used files and the user selects
a file from the list and it opens the file. But if someone is in the file
it takes a little longer to open but then it opens as read only but the user
does not get notification that the file was opened read only. Then if they
do something and then try to save the file it will tell them it is read only.
How do you tell the user that the file was opened read only right after the
file was opened.

This is what I am using. vOpen is a variable of the file that was seleted.
Workbooks.Open Filename:=vOpen, UpdateLinks:=3

Thank you for your help,

Steven

 

[Jim Rech]

If ActiveWorkbook.ReadOnly Then DoWarning

--
Jim
|I have an excel file with a list of commonly used files and the user
selects
| a file from the list and it opens the file. But if someone is in the
file
| it takes a little longer to open but then it opens as read only but the
user
| does not get notification that the file was opened read only. Then if
they
| do something and then try to save the file it will tell them it is read
only.
| How do you tell the user that the file was opened read only right after
the
| file was opened.
|
| This is what I am using. vOpen is a variable of the file that was
seleted.
| Workbooks.Open Filename:=vOpen, UpdateLinks:=3
|
| Thank you for your help,
|
| Steven