Macro to hide or unhide columns

[Guest]

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

 

[Fredrik Wahlgren]

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