Hello all,
Two issues I am experiencing with Data validation protections
If I set cells to unlocked, then create a Data validation, then lock the Spreadsheet, I cannot access the data validation in that cell.
Is there a VBA code to allow the Data validation to still work with a password protected Tab as I have lots of other data which should not be changed at all.
Is there a way to prevent accidental copy and paste of other cells over the top of a data validation cell?
Thanks
Bookmarks