View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
apache007 apache007 is offline
external usenet poster
 
Posts: 36
Default Protecting user from changing previous data

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.