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

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

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

"Tom Ogilvy" wrote in message
...
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