Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Macros
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formating and Macros | Excel Discussion (Misc queries) | |||
Conditional Replace without macros | Excel Worksheet Functions | |||
Conditional Formatting and Macros in Excel | New Users to Excel | |||
Macros warning always shows up, even if all macros removed | Excel Discussion (Misc queries) | |||
Conditional formatting based on decision to enable/disable macros? | Excel Discussion (Misc queries) |