Lock Data in cell after data entry

[Gavin]

I would like to enter data into my spredsheet using a form, however i would
like to lock the data in the cell after the data input in order that it
cannot be edited. Is this possible?

 

[Gord Dibben]

It is possible.

What type of "form"?

DataForm or UserForm or?

Where would the data be placed after entry in the form?


Gord Dibben MS Excel MVP

 

[Gavin]

Gord
My Plan is to create a user form with the information held in a spreadsheet.
I would also like to automaticall assign the next sequential number form
column 1 but again i am nit sure if this is possible.

Thanks

Gavin