Macro to hide columns based on Table Headers

I have a spreadsheet I use to track costs at various stores that I have set up with macros so I can just pick the store I am currently at and see that info only. It is a work in progress, and I want to add some new columns in it for more info. Doing that of course 'breaks' the current macros and then hides the wrong columns.

I need help updating my existing macros to hide based on table headers, not the column itself.
(Note - I only need one sample to go off of, I won't need all of my 'hide' macros updated.)

Please Login or Register  to view this content.

Thanks!

My suggestion:

Please Login or Register  to view this content.

Assign this macro to each shape. The procedure will find columns according to the shape caption.

Change the 2 in this line for the number of the first column that could be hidden.

Please Login or Register  to view this content.

So if the first column with a store name is E, it should be this

Please Login or Register  to view this content.

BSB

@BadlySpelledBuoy Thank you teaching me how to modify it correctly, I appreciate it!

@Tajan This macro also works beautifully, so thank you for you input

Glad we could help

BSB