Hi there Everyone! I have a very annoying problem. At our company there is a file which is used by many people. At this moment it is shared, so everyone can access it but this way (as many do not really understand excel) they save over each others rows, so many rows disappear. I would like to do the following with this file so no data will be lost, and everyone can save their data.
I would like to make something which works like this:

1. When I open the file (and it is not opened by anybody) I should get a userfrom asking for my name (combobox with names).
2. Then if the file is opened (by me) and somebody else tries to open it than he or she should get an error message, saying that: "This file is opened by John and you can access to it only when it is closed".

So (in case the file is opened by someone else) instead of getting the "open the file as read-only" the users should get an error message which says that they cannot access the file and a also show the name of the user who is working with the file. I hope you understand my problem and can help!
Thank you in advance!