Hi
When I protect a Worksheet I want the user to be able to select a cell to choose items from a cell validation list but also to prevent free typing into the cell. I understand that the cell validation will result in a msgbox if the user enters something not in the list but I'd like to do away with that by preventing them from keying in the first place, simply to select from what's available.
Is it possible?
Thank you
Bookmarks