| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open spreadsheet
Any help much appreciated! When a spreadsheet is opened using a button containing a macro from another spreadsheet, why doesn't it alert the user if someone is already in the file? It just opens a 'read-only' copy. Is there any way around this, with code or anything? Thank you! -- Grace79 ------------------------------------------------------------------------ Grace79's Profile: http://www.excelforum.com/member.php...o&userid=36435 View this thread: http://www.excelforum.com/showthread...hreadid=562024 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open spreadsheet
If ThisWorkbook.ReadOnly = True Then MsgBox "Read only" Else MsgBox " Read-Write" End If or... If ThisWorkbook.ReadOnly = True Then ThisWorkbook.Close Else MsgBox " read write" End If Duncan Grace79 wrote: Any help much appreciated! When a spreadsheet is opened using a button containing a macro from another spreadsheet, why doesn't it alert the user if someone is already in the file? It just opens a 'read-only' copy. Is there any way around this, with code or anything? Thank you! -- Grace79 ------------------------------------------------------------------------ Grace79's Profile: http://www.excelforum.com/member.php...o&userid=36435 View this thread: http://www.excelforum.com/showthread...hreadid=562024 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open spreadsheet
Check the readonly property of the workbook, and message it yourself
Workbooks.Open sFilename If activeworkbook.ReadOnly Then MsgBox "File already open, so it is readonly" EndIf -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Grace79" wrote in message ... Any help much appreciated! When a spreadsheet is opened using a button containing a macro from another spreadsheet, why doesn't it alert the user if someone is already in the file? It just opens a 'read-only' copy. Is there any way around this, with code or anything? Thank you! -- Grace79 ------------------------------------------------------------------------ Grace79's Profile: http://www.excelforum.com/member.php...o&userid=36435 View this thread: http://www.excelforum.com/showthread...hreadid=562024 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| spreadsheet does not open | Excel Discussion (Misc queries) | |||
| Can't see the open spreadsheet | Excel Discussion (Misc queries) | |||
| Spreadsheet will not open without Excel Application being open fir | Excel Discussion (Misc queries) | |||
| how do i do something for every spreadsheet i open? | Excel Programming | |||
| How to open another Excel spreadsheet to copy data into current spreadsheet ? | Excel Programming | |||
Linear Mode
