Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |