Automatically hide/unhide specific columns based on if any group of rows is expanded

[BKGLTS]

Hello,

I have a spreadsheet that has many row groupings.
There are columns that only need to be seen when any of these row groupings are expanded.
I figure this will require VBA code to accomplish.
Not in my wheel house.
Could someone please help by sharing code that will automatically hide/unhide specific columns based on if any group of rows is expanded?

For example:
Rows 1 thru 5 rows are grouped.
Rows 6 thru 10 rows are grouped.
Columns B thru F only need to be seen when either/any row groupings are expanded.

So when all the above groupings are minimized, columns B thru F are hidden.
If either or both the row groupings are expanded, columns B thru F will be unhidden.

Hoping this can be done and not too complicated.

Thank you!
B

 

[BKGLTS]

Hello All,

I havent received any responses the past two weeks, so just trying one more time before giving up on this.
Thank you.
B