Thread: Hide Columns
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rickey24[_4_] rickey24[_4_] is offline
external usenet poster
 
Posts: 1
Default Hide Columns

Hi all

The setup is I have weekdays listed starting with June 1st in C6 goin
horizontal across the whole sheet to IV6. I wanted to do
workbook_open event where it takes whatever today's date is and hide
the columns From C6 through yesterday. Essentially so today's colum
will be right next to the B column. So if today's date is in H6, C6-G
would become hidden when one were to open the workbook.

Thanks so much for the insight.
B

--
Message posted from http://www.ExcelForum.com