ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Unhide column based on subtotal level open. (https://www.excelbanter.com/excel-discussion-misc-queries/158600-unhide-column-based-subtotal-level-open.html)

GILBERT

Unhide column based on subtotal level open.
 
I have a sreasheet with five levels of subtotals and would like to automate
the hide or unhide column when I click on a specific level of subtotal.

Example: If I click on the expand my subtotals to the 2nd level, I would
like for column E to unhide. If I collapse my subtotals back to level one,
then I would like for column E to hide. I hope someone out there can help.


All times are GMT +1. The time now is 06:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com