This can be a very complex issue if you don't think things out really well
ahead of time. What happens if, after they've typed data in A1:D1 and while
entering more data in rows below row 1, they realize they made a mistake in
one of the entries above it? How do they correct the error?

How do you know they won't start in row 2 instead of row 1? Is that not
allowed at all?

Are the rows in your example already on the sheet for them to type into, or
do they actually have to use Insert -- Row to get a new row?


"apache007" wrote:

Hi All,

I have a block of data A1:D10 with Protection using ALLOW USER TO EDIT RANGE.

The user enter data with the following order:
Input 1: A1, B1, C1, D1
Input 2: A2, B2, C2, D2
Input 3: A3, B3, C3, D3


I would like to Automatically prevent the user from changing ROW A1-D1 when
Inserting NEW ROWS (Row A2-D2, Row A3-D3).

Thank you.