| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro in Excel with Pivot table
How can I ask the macro to run this the top sectionon every sheet that I
have. I want to create conditions in the top so I can change them easily and run those conditions to the below sheets. (I have a total of 30 sheets) With ActiveSheet.PivotTables("Tableau croisé dynamique1").PivotFields("Country") .PivotItems("Canada").Visible = False .PivotItems("Europe").Visible = True .PivotItems("US").Visible = True .PivotItems("US/Can").Visible = True .PivotItems("US/Canada").Visible = True .PivotItems("(vide)").Visible = True Sheets("Cktp E 26-32").Select Sheets("Cktp E 30").Select Sheets("Cktp E 36").Select Sheets("Cktp G 26").Select Sheets("Cktp G 30").Select Sheets("Cktp G 36").Select Sheets("Cktp I 30").Select Sheets("Cktp I 36").Select |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| pivot table macro | New Users to Excel | |||
| Pivot Table by Macro? | Charts and Charting in Excel | |||
| Is it possible to Macro a Pivot Table? | Excel Worksheet Functions | |||
| Pivot Table Macro | Excel Discussion (Misc queries) | |||
Threaded Mode
