VBA Show Certain Columns Hide Others

Hello,

I have this sheet that has columns for certain year months and totals.

Can VBA be assigned to the shapes designating the years so that when clicking it will only show the months and totals for that particular year and hide the other years?

For instance the shape 2023 will show columns E-R and hide columns S-EM.

2024 will show S-AF and hide E-R and hide AG-EM.

2025 will show AG-AT and hide E-AF and hide AU-EM.

Also there needs to be VBA to show all columns and VBA to hide columns E-EM.

Thank you very much for your help.

https://wellsr.com/vba/2020/excel/vba-hide-columns/

Please Login or Register  to view this content.

https://analysistabs.com/excel-vba/h...worksheet/#bm3

Please Login or Register  to view this content.

Thanks @Logit.

I did some work getting the correct columns assigned to each shape:

Please Login or Register  to view this content.

1. Assign this macro to all shapes that define years:

Please Login or Register  to view this content.

2. To both shapes specifying all columns, assign the macro:

Please Login or Register  to view this content.

3. Select all shapes and change their property to "Do not move or resize with cells"
4. Select whole rows 1:3 and give them the color of your choice.

Done.

Artik

Thanks for the help guys.

A small correction in the ShapeYear_Click procedure.
Instead of this line:

Please Login or Register  to view this content.

insert:

Please Login or Register  to view this content.

Artik

Thank you @Artik.