Clearing cells in excel before close - vba

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?

Please include code with response

to clear columns A:J

Please Login or Register  to view this content.

Kind regards
Leo