Select Entire Sheet and Delete all Cells Except Column A

Highlight col A. Format cells, protection, make sure locked is checked.
Choose all other columns, format cells, and unchecked locked in the same manner.
Right click the tab, view code, make sure the properties window is visible in the lower left
In the enable selection field, , change the selection to: 1 - xUnlockedCells Close the VBA explorer window.

Protect the worksheet. This will prevent users from messing with col A.

Hope it helps.
Pete

Hi Pete,

I'm so sorry for late reply. I didn't receive an email showing you had replied. I did use your instructions above. This is almost what I need although they want to be able to select the rows and delete the content except column A. I sent them the one per your instructions and told them I was still working on it but I don't know if it's even possible to do what they are asking at this point.

Do you know how to have the file just like you instructed above but for them to be able to select rows or select entire sheet while keeping Column A content protected? I really appreciate all of your help and time with your replies.