| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I stop 2nd row deletion
I have a data sheet with a header row. DATA1
All my calculations in other sheets refer to rangeNames that start with row2 in the DATA1 sheet. I have found that any row can be deleted from the DATA1 sheet BUT if row 2 deleted then the calculations fail. I would like code that would allow row 2 fields to be edited or corrected with PASTE Values but NOT allow row2 to be deleted. Any ideas? Dennis |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| #Ref! after row deletion | Excel Discussion (Misc queries) | |||
| name deletion | Excel Discussion (Misc queries) | |||
| How to stop sheet deletion | Excel Programming | |||
| How do I stop other circles in other cells to stop selecting? | Excel Worksheet Functions | |||
| How do I stop other circles in other boxes to stop selecting? | Excel Worksheet Functions | |||
Threaded Mode
