View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
geotso geotso is offline
external usenet poster
 
Posts: 10
Default 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