Simple macro to hide columns based on cell value

A simple macro that you can use to hide columns you do not want to see. Very useful for management reports where, each month, you easily want to see the selected month.

------------------------------------------------------------------------------------------------------------------------------------------------------

------------------------------------------------------------------------------------------------------------------------------------------------------
⏲Time Stamps
00:00 Hide/ Unhide columns based on month chosen in dropdown
00:25 Create a formula to show which columns should be hidden/ shown
01:50 Record a simple VBA macro to hide columns that say "Hide"
03:20 Create the button that will hide the other months
03:35 Record a macro to show all the columns again
04:20 Use the 'Hide' button to leave only the chosen month visible
04:28 Change the month and hide columns
05:05 NB- Save the file as an XLSM file (otherwise you lose the macro)

[rubyweaver]

Thank you! So easy to understand and execute!

[ravisiripuram]

Thank you Sir, this what exactly I was looking for...I saw lot of videos but couldn't understand but this one took 5min to execute. 👍

[ahmadnasir]

Hey man, thanks for sharing the useful way to do it, just wanted to understand, how to refresh and see both 1 and hide data points.

[chrisk.]

Try to connect that macro with specific cell change event for workbook then these buttons are not needed anymore.

[fahad]

thank you so much... really well explained but I am facing a weired issue...the macro works fine for the first time but after the macro is recorded and try to execute it again...then getting run-time error 1004...No cells were found...

Please help...feels like "almost there but yet so far"