Excel automatically hiding certain columns

[TanyaD]

Hi,

Hoping you can help me. I am completely new to VBA but definitely willing to give it a try and I suspect it may be the only option to do what I need.

I have a large detailed calendar schedule for seven staff (each day has a column for each staff member). I'm hoping I can include a button for each staff member so when I press that button it only shows the columns for that staff member.

I'm guessing that to only show for staff1 the code would say something along the lines of if row 2 (the row that staff names are in) is "staff2" or "staff3" or "staff4" or "staff5" or "staff6" or "staff7" then hide. Which would then only leave Staff1's columns showing?

Greatly appreciate any help on this.

Cheers,

Tanya

 

[TanyaD]

Hi again!

The spreadsheet has been working brilliantly, until someone else tried to use it on a Mac On the Mac when putting any staff & date combos in it will only show the first column for some reason. Is there anyway to make the code work on both Mac and PC?

Thanks,

Tanya

 

[Fluff]

I'm afraid that as I don't have a Mac, I have no idea.

 

[TanyaD]

No worries, I might start a new thread and see if there's any thoughts out there re Mac, thanks again for all your help