I asked the same question earlier today:

http://www.microsoft.com/office/comm...d-ecd7d910974f


--
Gary's Student
gsnu200706


"WDP" wrote:

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