View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default If excel sheet protected, combo boxes won't work

If you have a linkedcell to that combobox, make sure that it's an unlocked cell
on that protected sheet.

If you used data|validation, make sure that the cell is unlocked in this case,
too.

kiwimark wrote:

Can anyone help. I have an excel sheet with protection turned on, when I do
that I can't select data in my combo box drop downs.


--

Dave Peterson