collapse/expand

I am trying to write a personal macro script to Expand (Show Detail) or Collapse (Hide detail) of a very large (300R x 200C worksheet) that i frequently toggle between a summary view and full model view so i don't have to keep using my mouse click on the little 1-2-3 groups in the upper left...

I have a large set of data that I am making multiple pivot tables from. It is basically hours by date. The first table I built was for a summary that I will keep by month. The second is less permanent, but is taking the same data and summarizing by day. I discovered when I went back to the...

Hello, I am fairly new to VBA, having learned only from Bill Jellen's book. I adopted this code from his book, and it works fine if I line it line by line. If I run it by hitting F5, the resulting Pivot table is collapsed. I have to hit the Show/Hide +/- buttons to display the full pivot...

I have many columns (budget, forecast, and variance) for each month and quarter. I need to collapse and expand the variance columns as one group. How do I do this?

Hello,Is it possible to show the "+" and "-" signs WITHIN the main cell(of the worksheet, not a pivot table) rather than the signs showing in a bar to the left of the column when grouped?

Hi, I've recorded a macro to "collapse" a pivot table in a workbook. " Range("B23").Select ActiveSheet.PivotTables("PivotTable6").PivotFields("Account no. & name Concat") _ .ShowDetail = False Range("B22").Select ActiveSheet.PivotTables("PivotTable6").PivotFields("Name").ShowDetail = False"...

Hi, I'm trying to automate a micro to collapse/expand certain cells in a spreadsheet as data is put in (i.e. if Cell A>0, then Cells B-F will expand, if Cell A<0, then Cells B-F will collapse). Currently, the code WILL do that but only AFTER clicking the A column. Below is the code I use, any...