when you write the data, unprotect the sheet, unlock the cells, write the
data, lock the cells, protect the sheet.

--
Regards,
Tom Ogilvy

"Ed" wrote in message
...
I am using a UserForm to populate fields in a worksheet. The user fills
in
the fields in the Form and clicks the Enter Data button; the information
is
then transferred to the next available row in the sheet. I'd like to
protect the data from being able to be changed unless the user opens a
separate Edit Data Form.

What would be the best way to accomplish this? Through the SheetChange
event? Some setting of protection? What would you recommend?

Ed