View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.links
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Place source to drop down list in another spreadsheet

Don't hide the column with the validation list. Set the font color of the
items in that column to the same as the color of the cell. In the column the
list will be invisible, in the dropdown the list will still be visible.
--
Gary''s Student - gsnu200729