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...
 
Back
Top