Lock Data in cell after data entry

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?
 
G

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
 
G

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
 

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

Top