Hi, hopefully the last question for today...!
I have created a sheet, with validation data list of numbers 1-10 in it.
I have protected the sheet, but allowed users to edit that cell (i.e. select the figure from the drop down whatever it may be).
However, if they make a mistake and sleect '3' for example but meant '2', the protection is not allowing them to delete this and re-enter it.
Any ideas how I can allow this, in Excel 2010?