Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Read only
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I have a read only xl file, I need it to be read and write | Excel Discussion (Misc queries) | |||
Read-write/Read-only | Excel Discussion (Misc queries) | |||
XCEL FILE REC'D AS READ ONLY -- HOW TO NOT BE "READ ONLY" | Excel Discussion (Misc queries) | |||
How can a file be converted from Read-Only to Read/Write | Excel Discussion (Misc queries) |