I have created a workbook that opens a second workbook for
people to enter data.
But if somone else already has this second workbook open
then my workbook opens a read-only copy.
I've got an if statement that prevents people entering
data to a read-only copy, but it would be great to display
the name/ID of the person who does have it open, as would
happen if a person has opened it directly and not via my
workbook.

TIA

This suggestion by Tom Ogilvy works for me. However, there have been
previous threads concerning reliability,

http://www.google.com/groups?hl=en&l...0d05df4&rnum=5

Tested using Excel 97SR2 on Windows 98SE,

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------

I have created a workbook that opens a second workbook for
people to enter data.
But if somone else already has this second workbook open
then my workbook opens a read-only copy.
I've got an if statement that prevents people entering
data to a read-only copy, but it would be great to display
the name/ID of the person who does have it open, as would
happen if a person has opened it directly and not via my
workbook.

TIA

Yes you can do this programtically.
Have a look here for how to determine if a workbook is Open and by Who.


http://www.xcelfiles.com/IsFileOpen.html


am wrote in message . ..
This suggestion by Tom Ogilvy works for me. However, there have been
previous threads concerning reliability,

http://www.google.com/groups?hl=en&l...0d05df4&rnum=5

Tested using Excel 97SR2 on Windows 98SE,

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------

I have created a workbook that opens a second workbook for
people to enter data.
But if somone else already has this second workbook open
then my workbook opens a read-only copy.
I've got an if statement that prevents people entering
data to a read-only copy, but it would be great to display
the name/ID of the person who does have it open, as would
happen if a person has opened it directly and not via my
workbook.

TIA