Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Remove read only prompt
When a spreadsheet is open by a user and a second user wishes to open it, is
it possible to remove the read only prompt that appears in the box that says Read Only, Notify, Cancel? We wish it to be only viewed in any mode by one exclusive user at a time but I cannot find an option to do this. I've tried all the security settings etc. |
#2
|
|||
|
|||
Hi,
When that file is open, go to File-Save as. In the 'save as window' click on Tools-General options and uncheck 'Read-only recommended' and click on 'OK' and save the file with the same name & location. Regards Govind macsaintly wrote: When a spreadsheet is open by a user and a second user wishes to open it, is it possible to remove the read only prompt that appears in the box that says Read Only, Notify, Cancel? We wish it to be only viewed in any mode by one exclusive user at a time but I cannot find an option to do this. I've tried all the security settings etc. |
#3
|
|||
|
|||
Hi I followed your instructions but the read only is unchecked already
"Govind" wrote: Hi, When that file is open, go to File-Save as. In the 'save as window' click on Tools-General options and uncheck 'Read-only recommended' and click on 'OK' and save the file with the same name & location. Regards Govind macsaintly wrote: When a spreadsheet is open by a user and a second user wishes to open it, is it possible to remove the read only prompt that appears in the box that says Read Only, Notify, Cancel? We wish it to be only viewed in any mode by one exclusive user at a time but I cannot find an option to do this. I've tried all the security settings etc. |
#4
|
|||
|
|||
I think that this prompt pops up before the workbook is opened--it's windows &
excel working together to see that the file is in use. I don't think you can change this behavior. You could let the other user open it and close it if the file was opened in readonly mode, but sometimes it's very useful to be able to open in readonly mode. I wouldn't do this, but if you want, you can create a macro that does this check: Option Explicit Sub auto_open() With ThisWorkbook If .ReadOnly = True Then MsgBox "Opened in ReadOnly Mode--Closing!" .close savechanges:=false End If End With End Sub (but if macros are disabled, then this won't help either.) If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm macsaintly wrote: When a spreadsheet is open by a user and a second user wishes to open it, is it possible to remove the read only prompt that appears in the box that says Read Only, Notify, Cancel? We wish it to be only viewed in any mode by one exclusive user at a time but I cannot find an option to do this. I've tried all the security settings etc. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
remove enable macro prompt | Excel Discussion (Misc queries) | |||
How to CANCEL file SAVE PROMPT when MACRO is running? | Excel Discussion (Misc queries) | |||
Excel prompt inaccessible to users | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Remove link fr a column of entries | Excel Discussion (Misc queries) |