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?
Bookmarks