Ok, then have a look in vba help for selectcase

"Kevin" wrote in message
...
This seems like a simple thing to do, but I can't figure
it out on my own. Basically, I have multiple worksheets,
with successive months across the columns, and
corresponding data beneath. I want the user to be able to
quickly and automatically hide certain months in all of
the worksheets.

I was thinking of making seperate macros that hide
individual months, then having check boxes on a new
worksheet so that a user could just check the one he wants
to include/hide, then press a button, and it will run the
appropriate macros. I can make the macros, I just don't
know how to do some sort of "if" that will determine which
ones to run.

Ideally, I was hoping to just have a list box and have the
user select whatever months to inclue in this, but I
couldn't even get started on this, so I started the other
way. If you can help me with either of these methods, or
a different one, I will greatly appreciate it. Thanks.