Unchecking “Edit Directly In Cells” in my workbook performs as advertised - except in data validation cells. I have code to cancel before right click or double click, disable paste, and also to undo delete or backspace and replace my default entry. So the user is really locked in to selecting from the drop-down list - except in the one scenario where things get ugly;
Invalid entry is typed into the cell > error msg box pops up> user clicks “Retry”.
This is problematic because:
A - Calculations based on the DV selection return text in other cells. Clicking “Retry” causes these cells to return #VALUE! and ruin the otherwise professional look of the worksheets.
B - I want the users‘ options limited to selecting from the DV list. “Retry” simply adds an ugly step to an otherwise streamlined and professional looking process, making it necessary to delete, escape, or enter and then click “Cancel”.
And yes, my error msg box does say "Click Cancel", but we all know that will not stop anyone from clicking "Retry".
I need some code to prevent or undo ANY data entry in the cell.
Alternately, greying out “Retry” would be fine, but I believe that is impossible.
Thanks
Invalid entry is typed into the cell > error msg box pops up> user clicks “Retry”.
This is problematic because:
A - Calculations based on the DV selection return text in other cells. Clicking “Retry” causes these cells to return #VALUE! and ruin the otherwise professional look of the worksheets.
B - I want the users‘ options limited to selecting from the DV list. “Retry” simply adds an ugly step to an otherwise streamlined and professional looking process, making it necessary to delete, escape, or enter and then click “Cancel”.
And yes, my error msg box does say "Click Cancel", but we all know that will not stop anyone from clicking "Retry".
I need some code to prevent or undo ANY data entry in the cell.
Alternately, greying out “Retry” would be fine, but I believe that is impossible.
Thanks