Enable change only with Form?

[Ed]

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

 

[Tom Ogilvy]

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

 

[Ed]

Since data entry is made only through the form, would it make sense and save
steps to unprotect and unlock in Form_Initialize, and lock and protect on
Terminate? Or are there reasons I would want to do it on each data line
entry?

Ed