tags:

views:

76

answers:

1
Q: 

collapse subtotals to level 2 using VBA

does anyone know how to use VBA to collapse subtotals (once created) to level 2 so I only see the summary?

A: 

found out from Mf excel archive question -

ActiveSheet.Outline.ShowLevels 2

simple when you know how...

confused  2009-12-06 13:34:45

related questions

How can I refresh all the pivot tables in my excel workbook with a macro?
MS Access - Controlling another database in VBA
Deleting a file in VBA
How do you prevent printing dialog when using Excel PrintOut method
SQLite UDF - VBA Callback
Function Overloading in Excel VBA
How do I keep RecipientTime when executing MailItem.Move in an Outlook macro?
How do I assign a keyboard shortcut to a VBA macro in Outlook 2007?
Visual studio automation: Enumerate opened windows upon solution loading.
Hiding data points in Excel line charts
How do I create a status dialog box in Excel
Modifying a spreadsheet using a VB macro
Count a list of cells with the same background color
Templates In VB
Best way to test a MS Access application?
How do I read/write Person metadata from a Word doc stored in SharePoint using VBA or VSTO?
Excel VBA: Alternative IDE
good directory picker for visual basic macros in MS Outlook (2007)
Zoom for a windows form in C#
Excel: list ranges targeted by INDIRECT formulas
What is the best way to package and distribute an Excel application.
Alternating coloring groups of rows in Excel
Word Automation: Write RTF text without going through clipboard
How to parse XML in VBA
Refresh Excel VBA Function Results