+ Reply to Thread
Results 1 to 6 of 6

Cannot edit drop down menus

  1. #1
    Registered User
    Join Date
    11-06-2010
    Location
    South Africa
    MS-Off Ver
    Excel 2003
    Posts
    2

    Cannot edit drop down menus

    I have a spreadsheet (attached) designed to calculate the savings a customer can make by using our energy saving lights compared to their existing lights. We have upgraded our range, and I would like to introduce some options which reflect this.

    However, the drop down menus incorporating this information seem to be locked in some way, and I cannot access or modify the formulas or data that they refer to.

    You will see that the first menu includes the kinds of lights that the customer already has, and the one below has details of our lights. The titles for the menus are located in cells X7 and onwards. But as I say, the formulas remain elusive. How can I reach them? Thank you for your time.
    Attached Files Attached Files
    Last edited by GreenLite2010; 11-07-2010 at 06:45 PM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Cannot edit drop down menus

    The dropdowns are activex controls.
    First display the Control Toolbox toolbar.
    Go into Design mode, ruler/pencil/triangle icon.

    You can now select the dropdown and right click. Pick Properties and adjust the ListFillRange property.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,481

    Re: Cannot edit drop down menus

    In design mode( Visual Basics ToolBar), right click on the control and select Properties,
    adjust the list fill range there.

    The formula is in the Combo-box change code, right click on the sheet tab and select View code,.
    Are you able to talk to the person that actually made the workbook?
    Last edited by davesexcel; 11-06-2010 at 09:09 AM.

  4. #4
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Cannot edit drop down menus

    you have some hidden sheets format/sheets/unhide
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  5. #5
    Registered User
    Join Date
    11-06-2010
    Location
    South Africa
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Cannot edit drop down menus

    Thank you guys. I will proceed with this and get back to you with my results. Thanks so much for your valuable time and input.

  6. #6
    Registered User
    Join Date
    01-28-2011
    Location
    phila, pa
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: Cannot edit drop down menus

    Quote Originally Posted by Andy Pope View Post
    The dropdowns are activex controls.
    First display the Control Toolbox toolbar.
    Go into Design mode, ruler/pencil/triangle icon.

    You can now select the dropdown and right click. Pick Properties and adjust the ListFillRange property.
    I'm in Control Toolbox / Design mode but
    When I right click I don't have Properties to choose. (Excel 2003)
    I tried using Create list... instead of edit the existing list but it didn't like what I typed.

    The drop down is reading from the next sheet named LISTS in the same xls file and the list is in cells A2 thru A15 so I typed ='LISTS #'!$A$2:$A$15 it said reference not valid.
    thanks, db

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1