Hide/Unhide columns in multiple worksheets based on item chosen in a drop down list.

Hello everyone,

I am hoping to create a drop down list of months in one sheet, and when I select a certain month, columns in about 10 other worksheets in the same workbook will either hide or unhide columns...

The spreadsheet is laid out with columns (C-N) for each month in the year, for actuals, then columns for budget and budget variance (O-P), then YTD Actual, YTD Budget and YTD Variance. When I select September, for example, I want October-December to hide, and leave Jan-Sep unhidden, while keeping the budget, YTD and variance columns.

Is there a VBA code that can achieve this? I have searched through old threads and can't seem to find something identical to this issue.

Please help.

Sorry about that.. see attached..

I want a command to select a month is the "month" tab, and then the next few tabs after it will update there formatting. In my actual file, there are about 10 tabs that need to change.

Thanks for the quick reply. Let me know if this is possible.

Thanks alansidman

I got a runtime error '9' message when I tried running it. When I went to debug, it highlighted the Set w = Sheets("Month") line. Do you know what might be causing the issue?

Thank again for being so helpful with this.

Sorry about that.. I see what you mean.

I've attached the file I'm actually working on, and just deleted the content. There are 12 tabs (after the Month tab) that I am hoping will change.. I have the VBA code you provided me in this file.. can you test it and let me know if it will still work?

This is perfect.. thanks again for all your help with this.

My apologies on sending the first file. I was hoping to understand the coding you would provide and see if I could alter it my this second file I attached.

The hide and unhide buttons are very helpful.

Sorry to add to this closed thread. Can you explain the steps to adding the buttons.. i used the developer tab to insert them, and copied your coding into a module 3 in VBA, but I can't seem to get it to work on the file I'm trying to transfer your coding to.

The steps you took to insert everything would be very helpful.

This is perfect. It works! Thanks again alansidman! You were very very helpful.

Another option is to rope in alansidman code into a combo box and no need to have buttons to hide or unhide macros…the macros will automatically run when you select that month....attached is an example.

Thanks! This works well too.