In my workbook I have a sheet where all cells are unlocked. The sheet needs to be unprotected to allow pasting onto the sheet below row 8. After pasting the sheet is protected again.
Cell A1 of the sheet has Data validation (a list of two possible values) and I do not want the user pasting into it . if they to I want DV to prevent it.
How do I prevent pasting into cell A1 - I am open to VBA solutions.
Thank you
Allister
Cell A1 of the sheet has Data validation (a list of two possible values) and I do not want the user pasting into it . if they to I want DV to prevent it.
How do I prevent pasting into cell A1 - I am open to VBA solutions.
Thank you
Allister