Macro to Select Month and all other columns containing the months and years to be hidden

[Howardc1001]

I have Month and year in B4:M4

I would like a macro that when I select a month from a list then all the other columns containing the months and year to be hidden


I have attached sample data


Your assistance is most appreciated

[nankw83]

Hi Howardc,

Right click on sheet "BR1" tab --> View Code then paste the below ...

Please Login or Register  to view this content.

[Howardc1001]

Thanks for the help.

When I select say December , then I want the column containing December to be unhidden and all the other columns containing the months and year to be hidden

Kindly amend your code

[nankw83]

Try below code ...

Please Login or Register  to view this content.

[Howardc1001]

Thanks for much for your help

[nankw83]

Glad to help & thanks for the added Reps.