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

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" <[email protected]> wrote in message
news:[email protected]...
> 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

thanks ...that works

You're very Welcome!

Keep on Exceling....

--
steveB

Remove "AYN" from email to respond
"bobm" <[email protected]> wrote in message
news:[email protected]...
> thanks ...that works

worked for me too!!!