Cell Protection Issue with Userform

[kellem80]

Hi,
I have a user form that the users are supposed to use to enter data to a sheet. the form them inserts data into certain cells in the next available row, while leaving other cells blank for the user to enter the data directly into or the other cells in the row contain formulas.
I would like to prevent the users from directly entering the data on the sheet for the information they are supposed to complete via the userform, since it dates and codes their inputs and the form has the data in the correct nomenclature and formats for entry and for use with formulae throughout the workbook.
I tried using standard cell protection, but when it is on, it also won't accept the data from the form. The sheet is currently password protected for the cells that contain formulas, but not the other cells. (I am willing to change this if somebody can tell me how!)

Thanks!!
Kel

 

[ChrisM]

leave the sheet protected. In your form code, before you write its values to the worksheet just unprotect first:

sheet1.Unprotect "pw"
'write vaues
sheet1.Protect "pw"

 

[kellem80]

Chris thanks---question, "pw" does that indicate replacing "pw" with the password that I use to protect the sheet?
Thanks!
Kel

 

[kellem80]

works!! awesome!! Thanks!!

 

[apgmin]

Can you please help me how to do this form thing, really wonderful