VBA Pop-up
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...
Phil
Posted by Russell on June 04, 2001 8:37 AM
What I would do is have the users go into their Tools-Options, General tab, and type in their name under "User name". This will tell you who has it open and will save you unnecessary coding.
Hope this helps,
Russell
