Thread: Read only
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Read only

If ActiveWorkbook.ReadOnly Then DoWarning

--
Jim
"Steven" wrote in message
...
|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