macro showing and hiding detail

K

KC

I have a spreadsheet that has about 20 tabs in it. Each tab has data in it
that I update weekly. I have 3 columns grouped (the + & = sign) in each tab
that I show the group so I can update a cell within that group, then I close
the group, and C & P the table into a PPT file. I then repeat with all the
20 tabs.

I tried to create a macro to show the groups on each of the 20 tabs, then
another macro to hide the groups, however, when I ran the macro it didn't
work. The macro only recorded me going into each tab. Is there a way to
create this macro?
 
P

Paul C

The recorder does not grab this, but the code syntax is
This expands to level 2
ActiveSheet.Outline.ShowLevels RowLevels:=0, ColumnLevels:=2
This collapses to level 1
ActiveSheet.Outline.ShowLevels RowLevels:=0, ColumnLevels:=1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting Outlook 2007 contact list without losing groups 0
Setting column width in a table with a macro is not working 0
Macro Loop 0
Menu Macro Not Executing - Need Help 1
Select Text to End of Footnote 9
Consolidation Table from Different Excel Tabs with Different Format 1
Drop down list control value in vba 2
Macro to delte Duplicate rows across multiple sheets 0

Top