Lock Data in cell after data entry

  • Thread starter Thread starter Gavin
  • Start date Start date
G

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?
 
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
 
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
 
Back
Top