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


"WDP" wrote in message
...
I have an Excel file on an FTP Server.

Once a 2nd user opens this file.....I would expect this user to get a
"Read-only" message......but this is NOT happening.

I need the "read-only" message to pop-up IF the file is in use

Is there any type of code I can enter into my workbook to force this?

Thanks

Warren Phillips