Overwriting problem.

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

Thanks for the quick reply Roy.

So if attach that to the CmdAdd button at the start is should check if it's open and then open it if it's not. Also when it is open does it wait till it is closed until it opens to prevent overwriting.

sorry to be a pain buddy and i really appreciate the advice.

Cheers Dave

Nice one Roy,

You Da' Man

Appreciate all the help, one day i will be in your shoe's!!!