> In K23:K42 I am looking to add a formula (help) If C23 = "" or then "", If not "REMOVE ITEM".
In K23, enter the formula
and fill down to K42.
> I would like K23:K42 to be locked, unless "REMOVE ITEM".
I'd leave these cells locked too, otherwise the user could overwrite the formula.
> I want the "REMOVE ITEM" to be a hyperlink?? (or use a double click event) that activates a macro to clear the contents and formats of the 10 cells to the left.
You can use the Worksheet_BeforeDoubleClick event. If you have protected the sheet normally (using Tools | Protection | Protect Sheet...), you'd have to unprotect it, clear a range, then reprotect it in code. But you could protect the sheet using code the following way instead:
That way, the sheet is *not* locked for manipulation by VBA code. So the Worksheet_BeforeDoubleClick code will not have to unprotect and reprotect the sheet.
Code (in the worksheet module):