You can check if the ReadOnly property of the newly opened workbook is
true. If so, its open with another user.
--
mrice
------------------------------------------------------------------------
mrice's Profile:
http://www.excelforum.com/member.php...o&userid=10931
View this thread:
http://www.excelforum.com/showthread...hreadid=532753