Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down box
Does anyone know if there is a way to create drop down boxes on a shared
worksheet. I did a little research, and the only way I saw to do it is with Data Verification. But that option is greyed out when the worksheet is shared. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down box
You can not create the drop down on the fly. Sharing is essentially a form of
protection which excludes a bunch of functionallity. You need to unshare the spreadsheet. Add the drop down. re-share the spreadsheet... -- HTH... Jim Thomlinson "dbs" wrote: Does anyone know if there is a way to create drop down boxes on a shared worksheet. I did a little research, and the only way I saw to do it is with Data Verification. But that option is greyed out when the worksheet is shared. Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down box
Thanks! It worked just right.
"Jim Thomlinson" wrote: You can not create the drop down on the fly. Sharing is essentially a form of protection which excludes a bunch of functionallity. You need to unshare the spreadsheet. Add the drop down. re-share the spreadsheet... -- HTH... Jim Thomlinson "dbs" wrote: Does anyone know if there is a way to create drop down boxes on a shared worksheet. I did a little research, and the only way I saw to do it is with Data Verification. But that option is greyed out when the worksheet is shared. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
how do I link a drop down list entry to a new drop down cell? | Excel Discussion (Misc queries) | |||
Cross-referenced drop-down menu (nested drop-downs?) | Excel Worksheet Functions | |||
drop down selection determines other drop down content | Excel Discussion (Misc queries) |