View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chance224 Chance224 is offline
external usenet poster
 
Posts: 21
Default 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