macro with vba forms updated by multiple users in real-time

You have to be rather experienced with Excel and Excel VBA to overcome the limitations of Excel in this respect. If you are not that advanced you'd better look for another solution. (the most simple one. to use a txt-file that will be opened for writing only and after writing will be closed a soon as possible)

Hi Guys, thanks for the fast reply. Yes I agree. I guess I'll switch to a real database.