drop down box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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...
 
Thanks! It worked just right.

Jim Thomlinson said:
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...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Expanded Drop Down Box Question 2
Create Drop Down Box populated by a List 1
Auto filter drop down box 1
how to delete drop down boxes 2
How to delete a drop down box in Excel 2007 1
Filtered drop down list 2
Restrict Choice in Shared WB (drop down alternative)? 0
Fill Drop Down with List 2

Back
Top