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

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