VBA/macro to hide columns based on particular week ?

Hi,

Here's my case: I'm making a workshift planning calendar for my work. I'm using 365 columns for each day of the year. As you can imagine, this translates in a very wide column navigation, making it hard to focus.
I intend to work on a week basis, so I only need to show 7 columns (7 days, based on week number) at the time, everything else should ideally be hidden. I would then use buttons to navigate from a week to another.

For know I've used the cell grouping function but I would like something cleaner without distractions.

Is it someting easy to do?

Thanks for your help


P.S. - sorry if the topic is repeated or if I'm posting in the wrong place

I ungrouped the columns then I tried below

see if it works for you

Please Login or Register  to view this content.