Hi Guys,

I hope someone can help, and i'm sure you guys will be able to.

I have a single spreadsheet which simply has a cover and a button that opens a userform. when the form is completed they user selects the done button. This opens another spreadssheet and logs the captured data in the relevant sheet.

however when 2 people try to enter data at the same time they are unable to do so obviously because someone is already in the file.

i have set the done button to open the file, eneter the data, save and close
but is there anything else i can do to prevent this happening like a loop that check to see if the file is closed then runs the done command or waits until it is closed then runs?

cheers for reading my threat and thanks