| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lock Data in cell after data entry
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lock Data in cell after data entry
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 On Thu, 5 Mar 2009 11:00:01 -0800, Gavin wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lock Data in cell after data entry
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 "Gord Dibben" wrote: 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 On Thu, 5 Mar 2009 11:00:01 -0800, Gavin wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
| lock cell conditional format but not restrict data entry | Excel Worksheet Functions | |||
| Lock Row after Data Entry | Excel Discussion (Misc queries) | |||
| Lock Cell After Data Entry | Excel Discussion (Misc queries) | |||
| Is there a way to lock out the format for the cell and still allow data entry and C&P? | New Users to Excel | |||
Linear Mode
