Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to hide or unhide columns
I have 12 columns for each month with various totals listed in rows. Between
each month I have columns for each day on the month. Those columns are hidden for reporting and visual purposes. The monthly columns total of off of the daily ones. Is there a way to create a macro that would work using a short cut such as €œCtrl+1€ for January €œCtrl+2€ for February and so on that would either hide the specified columns or unhide them. Thanks, Chance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to hide or unhide columns
"Chance224" wrote in message ... I have 12 columns for each month with various totals listed in rows. Between each month I have columns for each day on the month. Those columns are hidden for reporting and visual purposes. The monthly columns total of off of the daily ones. Is there a way to create a macro that would work using a short cut such as ?oCtrl+1? for January ?oCtrl+2? for February and so on that would either hide the specified columns or unhide them. Thanks, Chance You can easily record a macro that hides or unhides a column. I'm not sure whethere it's a good idea to use a shortcut for each possible combination, what would you use for November? Wouldn't it be better to basse the logic on the current month or a value in a cell? /Fredrik |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Hide-Unhide Columns with a macro | Excel Discussion (Misc queries) | |||
Auto Hide-Unhide Columns with a macro | Excel Discussion (Misc queries) | |||
Hide/Unhide columns using button on top over relevant columns | Excel Discussion (Misc queries) | |||
Unhide and hide columns | Excel Worksheet Functions | |||
How do I hide or unhide zero value columns/rows USING A MACRO? | Excel Discussion (Misc queries) |