View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Curious Consultant Curious Consultant is offline
external usenet poster
 
Posts: 1
Default 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?