Excel should take care of this automatically on opening, providing th
workbook is not set up for sharing, by forcing it to become Read Onl
if someone else is using it. You can then do a check with somethin
like :-

'-----------------------------------------
If ActiveWorkbook.ReadOnly = True Then
MsgBox ("Someone else is using this workbook. Please try agai
later.")
End
End If
'-----------------------------------------

--
Message posted from http://www.ExcelForum.com