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

Macro on a Pivot Table 1
Macro 3
Macro to hide/unhide WS based upon WS tab color 2
MACRO QUESTION 1
Convert to Values 2
Run Macro Automatically When Excel 2003 Opens 2
Macro to create formula in cell 2
Problem with 2007 saved as 2003 2

Top