Delete record(s) in other cells based on value of one cell.

M

MPope

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
 
D

Dave Peterson

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