only edit from userform
 

Is it possible to make a worksheet only editable from the user form?

I want to stop people editing directly because they keep entering stuff
incorrectly.

only edit from userform
 

Protect the sheet with the UserInterFaceOnly:=true parameter which allows
your code to update a protected sheet with locked cells.

Prior to that, lock all the cells and protect the sheet. In xl2002/3
disallow user selection of any cells. In earlier versions set the
EnableSelection property of sheet to xlNoSelection.

Of course you will have to evaluate this advice in terms of the
functionality you want to offer the user in terms of use of the worksheet.

An alternative approach might be the Application.Interactive property. See
the help for details.

--
Regards,
Tom Ogilvy


"mg_sv_r" wrote:

Is it possible to make a worksheet only editable from the user form?

I want to stop people editing directly because they keep entering stuff
incorrectly.