http://support.microsoft.com?kbid=138621
XL: Macro Code to Check Whether a File Is Already Open

http://support.microsoft.com?kbid=291295
XL2002: Macro Code to Check Whether a File Is Already Open

http://support.microsoft.com?kbid=213383
XL2000: Macro Code to Check Whether a File Is Already Open

http://support.microsoft.com?kbid=184982
WD97: VBA Function to Check If File or Document Is Open

--
Regards,
Tom Ogilvy



"Fio " wrote in message
...
This is a little odd, but I would like to run a loop until a workbook is
free to write to it ...

I would like multiple users to write to a book - it doesn't matter
which one ... but I don't want them to get any 'wait' 'free to write
to' share messages if it's active ...

If I have my book (active) , book1 (closed) and book2 (closed) ..
I would like to run a loop until either book1 or book2 are closed then
open the book, write to it, close the book ...

Currently I have -