Work around for saving a shared doc at the same time?

Question

I have 6 computers that a shared VBA Form in excel is pulled up on.

My problem is, is that the document is frequently saved and updated. The people that enter information will save the entry at the same time as another is saving and it causes an error. That error causes it to crash and we need to repull up everything which takes awhile, and hoping it didnt loose the entry.

Is there a way to prevent this from happening altogether? or is there a code that if the save error occurs, a msgbox will pop up and say "This Document was saved at the same time as another" and then maybe a "Try Again" button on it, that will continue saving the entry?

Any help would be awesome! Thank you!