Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Sep 2010
    Location
    Cheltenham, Gloucestershire, UK
    Posts
    12
    Thanks
    4
    Thanked 0 Times in 0 Posts
    I have a shared spreadsheet with combo controls which can be selected in 2003 - but in 2010, unless I remove sharing, the combo controls are not selectable.

    I have tried saving as a 2010 macro enabled workbook - but this makes no difference. I have also tried recreating the combo control in a macro enabled 2010 spreadsheet but have the same problem.

    Is there anyway this can be resolved?

    Thanks

    Roberta

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    This is a bug in 2010 with shared workbooks and ActiveX controls - MS are aware of it. The current workarounds are basically to use Forms controls instead, or don't share the workbook (that latter is good advice generally anyway).
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    New Lounger
    Join Date
    Sep 2010
    Location
    Cheltenham, Gloucestershire, UK
    Posts
    12
    Thanks
    4
    Thanked 0 Times in 0 Posts
    Many thanks - I thought it was me!!! Regards Roberta

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •