View Single Post
  #1   Report Post  
MPope
 
Posts: n/a
Default Delete record(s) in other cells based on value of one cell.

What I have is a protected sheet, where all columns except for 3 are
protected. I cannot delete the entire row with protection turned on. So,
what I need is to be able to delete the value in these three columns, only
when the value in column A is "d".

Any clues?

Protection must remain on, users are using this spreadsheet and I cannot
allow them to have access to the formulas in these other columns.

Help...Micheal