| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
stop excel file opened as read only if already opened by another u
hello,
how do i prevent an excel file being opened as read only if the file is already opened by another user. this particular file is on the file server and accessed by multiple users. What I want is an alert if the file is already opened which says the file cannot be opened as read only and click ok to close. the alert to inlcude the username who has the file opened. workbook sharing is not an option as it breaks my various vba macros appreciate any help... cheers |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
stop excel file opened as read only if already opened by another u
Play with this code (place it in your wb open code)
If ActiveWorkbook.ReadOnly Then ActiveWorkbook.Close FalseEnd If -- steveB Remove "AYN" from email to respond "bobm" wrote in message ... hello, how do i prevent an excel file being opened as read only if the file is already opened by another user. this particular file is on the file server and accessed by multiple users. What I want is an alert if the file is already opened which says the file cannot be opened as read only and click ok to close. the alert to inlcude the username who has the file opened. workbook sharing is not an option as it breaks my various vba macros appreciate any help... cheers |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
stop excel file opened as read only if already opened by anoth
thanks ...that works
|
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
stop excel file opened as read only if already opened by anoth
You're very Welcome!
Keep on Exceling.... -- steveB Remove "AYN" from email to respond "bobm" wrote in message ... thanks ...that works |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2003 Can I stop the 'update links' option when file is opened? | Links and Linking in Excel | |||
| How to stop Excel remembering/loading macro from previously opened Workbook | Excel Discussion (Misc queries) | |||
| Excel file opened as read-only, if saved by another user | Excel Discussion (Misc queries) | |||
| Is Workbook read-only because of file permission or because file is already opened? | Excel Programming | |||
| Excel ADO connection opens read-only instance of opened Excel | Excel Programming | |||
Hybrid Mode
