Hi, first post. Have searched and found responses to this, but none have worked in my sheet. I have virtually no VBA experience but am learning it while creating this worksheet.

I am creating a budget template for the public to download and use to fill in for grant applications. It contains many formulas and macros so the sheet is protected except for the cells the users can enter budget info into.

Users will often cut and paste from an outside source, like Word or another Excel sheet, and then move the budget line items around once they're pasted into the template. But at the moment you can paste but then the cell becomes locked afterwards so no further changes can be made.

Is there a simple VBA code, or another way, to make sure the status of the cell (ie unlocked) remains after being pasted into?

Thanks