MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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...


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,