Posted by Phil on June 04, 2001 1:57 AM
I have given several people access to a shared excel document via the serve....
However they are constantly leaving this open & thus locking it as read only for all the other people.
To get around this whati would like to do is setup a pop-up box that asks the person opening the file what their name is and then it saves the name on a sheet called current user... thus if I open the document and it is read only i can look at the current user sheet to find who has locked.
All help is greatly welcomed and if any1 has any onther/ better suggestions how to get around this please let me know...