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

Provide a macro that unprotects the worksheet, does the work and reprotects the
worksheet is one way around the problem.

MPope wrote:

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

--

Dave Peterson