Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro showing and hiding detail
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro showing and hiding detail
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 -- If this helps, please remember to click yes. "KC" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding and Showing Sheets using Macro | Excel Discussion (Misc queries) | |||
Showing and hiding series in charts | Excel Discussion (Misc queries) | |||
Resetting view when hiding detail in outline level | Excel Discussion (Misc queries) | |||
hiding and showing graphs | Excel Worksheet Functions | |||
Protected worksheet, showing and hiding Grouped detail | Excel Discussion (Misc queries) |