Error Handling - Shared Spreadsheets (2 users saving simultaneously)

hi Everyone

I haven't started writing a macro for this yet but I was wondering if anyone had any potential solutions.

Basically I'm going to have a low traffic shared spreadsheet and a user form based system to add rows of data to the workbook. I need an error handling thing in place so that if 2 users happen to save at the same time and excel tries to put both peoples data in the same row, then it will give 1 user an error to try again and then make excel use the next row instead as at the moment it kills the process and gives the user a runtime error that's quite messy... Any ideas would be very helpful :-) thanks

Read this article of sharing of spreadsheet: https://support.office.com/en-ca/art...4-0ca4658b0c61