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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lock out data entry in a cell 1
Lock format but allow data entry 1
How do you lock a cell with data but still allow new data entry? 1
lock button after click 1
Locking A cell determined by data 12
Data copy locks cell in worksheet 3
How do I lock several sheets 4
12 Sheets - Submit to One Main Spreadsheet 2

Back
Top