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