expanding subtotals

J

JT

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...
 

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

Top