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?
Hi NJS1982,
Rather than deleting 3, users can choose 2 from the drop down list... why you want them to first delete 3 and then choose 2 from the drop down list ?
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks