ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   combo box protection (https://www.excelbanter.com/excel-discussion-misc-queries/104292-combo-box-protection.html)

jimmy g

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.


All times are GMT +1. The time now is 11:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com