+ Reply to Thread
Results 1 to 4 of 4

Macro to Hide Graph Worksheets -> Unhide Specific Graph Wkst. -> Calc. Specific Graph Wkst

  1. #1
    Registered User
    Join Date
    09-12-2012
    Location
    Juneau, Alaska
    MS-Off Ver
    Excel 2010
    Posts
    4

    Macro to Hide Graph Worksheets -> Unhide Specific Graph Wkst. -> Calc. Specific Graph Wkst

    Hello,
    I have a workbook with four worksheets: (1) 'Raw_Data', (2) 'Income_Graphs', (3) 'Employment_Graphs', and (4) 'Output_Graphs.' The raw data is linked with the other three worksheets using lookups to provide summary tables (that produce graphs) for income, employment, and output.

    I have an ActiveX list box where users can choose a community (e.g. Denver); this updates the data on the three graph spreadsheets. I also have an ActiveX list box where users can choose the types of graphs they'd like to see (e.g. income, employment, or output).

    My question: If the user chooses 'Denver' and 'Income Graphs' from the two list boxes, what would the macro look like to do the following: Hide the 'Employment Graphs' and 'Output Graphs' worksheets -> unhide the 'Income_Graphs' worksheet -> calculate the 'Income_Graphs' worksheet?

  2. #2
    Registered User
    Join Date
    09-12-2012
    Location
    Juneau, Alaska
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Macro to Hide Graph Worksheets -> Unhide Specific Graph Wkst. -> Calc. Specific Graph

    Attached is a sample of the workbook that I previously described.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    09-12-2012
    Location
    Juneau, Alaska
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Macro to Hide Graph Worksheets -> Unhide Specific Graph Wkst. -> Calc. Specific Graph

    Thank you in advance for any suggestions that you can offer; I would be grateful for any advice.

  4. #4
    Registered User
    Join Date
    09-12-2012
    Location
    Juneau, Alaska
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Macro to Hide Graph Worksheets -> Unhide Specific Graph Wkst. -> Calc. Specific Graph

    Please help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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