Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I do not have much experience in macro programming, but now I would need to make a macro. Can someone please help me?? In one excel worksheet called "Menu" I have put a lookup function in cell (A5). This function presents values 1 to 12 (and cell B5 has a similar lookup function presenting month January to December), depending on value chosen in a drop down list. If value in cell A5 is 1 (January in cell B5), I would like to hide some columns in another worksheet called "Output", say columns U to Z. I think that for hiding the columns I can use: Columns("U:Z").Select Selection.EntireColumn.Hidden = True But I don't know how to start this macro, I don't know how to do the selection of columns depending on the value in cell A5(can I use an IF function?), and how to select the worksheet "Output"?? Can someone please help? Thanks a lot, Kristine |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hiding rows or columns based on cell contents | Excel Discussion (Misc queries) | |||
Hiding columns in a protected sheet | Excel Discussion (Misc queries) | |||
hiding columns, error message says cannot shift objects off sheet | Excel Discussion (Misc queries) | |||
when hiding columns mess: "cannot shift objects off sheet" | Excel Discussion (Misc queries) | |||
Hiding columns, custom views, protected sheet | Excel Discussion (Misc queries) |