Results 1 to 4 of 4
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts

    Find "trigger" resulting from drop-down

    I have inherited a spreadsheet that has a drop-down menu from which there are 6 selections.
    When a selection is made, a block of cells changes (e.g., sorts on the basis of column 1, or 2, or some other change).
    I thought there was a macro associated with this but cannot find one from the developer tab (2010).

    Where is the code that is being executed when the option is selection? I'm missing something obvious, obviously.


  2. #2
    3 Star Lounger
    Join Date
    Apr 2002
    Location
    Redditch, Worcestershire, England
    Posts
    233
    Thanks
    0
    Thanked 22 Times in 21 Posts
    Quote Originally Posted by kweaver View Post
    I have inherited a spreadsheet that has a drop-down menu from which there are 6 selections.
    When a selection is made, a block of cells changes (e.g., sorts on the basis of column 1, or 2, or some other change).
    I thought there was a macro associated with this but cannot find one from the developer tab (2010).

    Where is the code that is being executed when the option is selection? I'm missing something obvious, obviously.

    Are you able to post the file or a subsection so we can take a look?

    Have you found any macros at all in the file? There could be a macro linked to the dropdown change, some sort of event macro firing as the result of a cell value change, or something else going on like a hook into cell validation...

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    The workbook is too large to upload. I'll have to see if I can pull a subsection of it.
    I don't see any macros in the workbook at all from the developer tab in 2010.

    Thought I found the macro, but I was mistaken.
    Last edited by kweaver; 2012-06-15 at 11:17.

  4. #4
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    Hi

    Try right-clicking on the sheet tab, and then selecting View Code from the right-click menu that is displayed.

    zeddy

Posting Permissions

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