| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protecting Cells from changing or modifying long formulas | Excel Discussion (Misc queries) | |||
| previous number not changing | Excel Worksheet Functions | |||
| Copying formulas without changing previous results/calculations | Excel Worksheet Functions | |||
| Changing dates entered in 2005 to previous years | Excel Worksheet Functions | |||
| A "previous" button on a user form | Excel Discussion (Misc queries) | |||
Threaded Mode
