I am stumped. All I want to do is have the user be able to select entire sheet or even rows and hit the delete button to erase all contents of cells except column A. I tried the lock and protect sheet method but that's not what they want. The would like to specifically select the row and delete all contents of row except column A. Can you fine folks help me out? This is almost embarrassing to ask because it seems to be something fairly simple; however, not simple enough for me I suppose.

Thank you in advance for your help.

Sheffcourt