Clearing cells in excel before close

I am trying to clear columns A:J of a protected workbook before close. How do I do this?

Is there also a way to allow people to paste information into column A:J to run a macro but not make any changes to the workbook? I am finding that I am having to fix the macro a lot because people are deleting and moving things they shouldn't be.

Ideally, before close I'd like Columns A:J to clear and then upon open the user can paste data into columns A:J and click the Macro button, but from there they cannot delete or edit anything. Is that possible?

You could password protect the worksheet and leave the columns A:J unlocked.
This will prevent them from deleting things.

Then what I do in many of my sheets is I clear the cells upon opening of the workbook.

Using in VBA module.
Auto_Open()

Enter your Code

End Sub