#1   Report Post  
Posted to microsoft.public.excel.misc
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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro that can run combo boxes simonsmith Excel Discussion (Misc queries) 0 June 5th 06 05:00 PM
Macro to automate page protection based on combo box reply wongard Excel Discussion (Misc queries) 9 September 9th 05 06:47 AM
Nesting Combo Boxes /Returning an Array ELMONDO SNITHER Excel Discussion (Misc queries) 1 June 30th 05 01:15 AM
Combo boxes and Protection [email protected] Excel Discussion (Misc queries) 0 June 27th 05 03:40 PM
dynamic combo boxes tjb Excel Worksheet Functions 2 January 25th 05 07:33 PM


All times are GMT +1. The time now is 04:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"