View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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