| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lock a total row below a list & allow inserting in the list?
When I place a total row below, but outside of, a list and another
calculated row below that then lock and protect only the total and calculated rows, the insert function in the list goes away. I want to allow users to add new records to the list but not change the formulas in the two rows below the list. Is this possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find numbers in a list which sum a total | Excel Worksheet Functions | |||
| Can't lock down a defined name list - help! | Excel Discussion (Misc queries) | |||
| look for one total from a list of numbers | Excel Discussion (Misc queries) | |||
| list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 | Excel Worksheet Functions | |||
| how do I add a list of numbers to get a total | Excel Discussion (Misc queries) | |||
Threaded Mode
