Data validation with dropdown list
"dhstein" wrote in message
...
I tried it and got the same result. I have two suggestions - one is to
hide
the entire column where the list is coming from - that works - the other
is
to move the data far away to the right somewhere - sorry - but that's the
best I could come up with.
Thank you for your suggestions...
Well, waiting for an answer, I tried some tricks and finally ended up with
this one:
Format the font of the cells where the lists are coming from with white
color.
Unlock only the cells that a user should use.
Protect the sheet with just the "Select unlocked cells" option enabled.
Well, that's it! And I think it's close enough to what I was trying to
accomplish at first place!
Thanks again
|