Miranda has attended:
Excel Intermediate course
Excel Advanced course
Data Validation
How do I prevent incorrect data values from being inputted into a cell?
I understand how to apply settings to list the type of data value that will be permitted in the cell, and am aware of how to create a input message when the validated cell is selected.
With the above applied, it is still possible to copy and paste a cell without validation applied, paste it into the validated cell and still be able to input an incorrect entry. Is there a way or preventing this from being possible?
RE: Data Validation
Hi Miranda,
Thank you for using the forum to ask a question.
Data Validation has a limitation that it can be overridden by pasting over that Cell, you are correct.
There isn’t a simply way of fixing this. The only work around requires VBA code. You can create a Macro to prevent changes.
This isn’t a perfect solution. If Macros are disabled, which they are by default when you open Excel files, the VBA Code won’t work to prevent pasting.
If you do use a Macro and enable them to run you will lose the Undo Button Functionality, Macros cannot be undone.
If you want help with the VBA Code to prevent changes, please let me know.
Kind regards
Richard Bailey
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
