How do you lock a cell with data but still allow new data entry?
 

I have a spreadsheet that will be accessed by multiple users. Each user will
fill out a row of data, save and close the spreadsheet. We do not want users
to edit rows after data is entered into a row of cells. Is there any way to
lock this data to prevent it from being edited? Thanks

How do you lock a cell with data but still allow new data entry?
 

Yes, but only with VBA and a Protected Worksheet.

The code for this is available.

Questions.................

1. You say users fill out a "row of data"...................how many
columns would that row contain?

e.g. A to F or ??

2. Do users fill out all cells in that row's range?


Gord Dibben MS Excel MVP

On Wed, 19 May 2010 13:05:01 -0700, Jessica
wrote:

I have a spreadsheet that will be accessed by multiple users. Each user will
fill out a row of data, save and close the spreadsheet. We do not want users
to edit rows after data is entered into a row of cells. Is there any way to
lock this data to prevent it from being edited? Thanks