Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
expanding subtotals
I have a button in my spreadsheet that creates subtotals. After the
subtotals are created, I'm hiding several columns so the user can see the item, the balance, and the aging categories all next to each other. If a user wants to expand one of the subtotals by clicking on the plus sign, I would like to unhide the hidden columns, so they can see all of the data. Conversely, if they collapse a subtotal, I would like to hide the columns again. Is it possible to hide and unhide columns when the user expands or collapses the subtotals? Any help getting started would be greatly appreciated. Thanks for all of the help... -- JT |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotals problem: Excel 2003 (not, AFAIK, the nested subtotals bug) | Excel Discussion (Misc queries) | |||
Subtotals function offset subtotals summary | Excel Programming | |||
Subtotals: Nested subtotals below higher subtotal | Excel Discussion (Misc queries) | |||
Problem with nested subtotals, placing secondary subtotals BELOW . | Excel Discussion (Misc queries) | |||
why are nested subtotals coming out below outer subtotals? | Excel Worksheet Functions |