Thread: hide combo box
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jd jd is offline
external usenet poster
 
Posts: 91
Default hide combo box

Based on selections that a user makes at the beginning of my Excel file, I
would like certain combo boxes (form control) to be seen and other combo
boxes to be hidden. Is there a way to hide combo boxes (form control)?

I know it would be easier to just use a list in data validation, but I am
trying to make this as user friendly as possible. Meaning, I want the arrows
to be seen in the drop down at all times, not just when the cell is active
(which is the case with data validation - unless there is something I am
missing there).

Thank you!