View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jimmy g jimmy g is offline
external usenet poster
 
Posts: 2
Default combo box protection

I have designed a form in excel and am using combo boxes from the control
toolbox because they have formating options,unlike the combo boxes from the
forms tool box. Everything works fine until I send the form to my business
associates to review. They can not use the drop down boxes; when they move
the pointer to them, and click, they end up in edit mode. This is true even
with a protected sheet. How can I send the form out so it will not allow any
combo box editing ? IT's almost as if the default forthe combo conrtol is
design mode open. Thanks.