Hi,

I'd like to create a macro that will hide rows based on today's date. I'd like to hide any rows that include dates that are one week old or older. I'd then like the macro to run automatically on opening the workbook. Some dates have passed already. Ideally, the rows with dates that are older than 1 week, would hide automatically when I open Excel.

Sample workbook:
Cells A3:A22 have dates 4/1/14 thru 4/20/14
Cells B3:G22 have other data

I'd like to create a macro and have it run automatically that will hide any row that has a date in column A that is 7 days or older. In this case, if I open the workbook on 4/15/14, the macro would hide rows 3 thru 10, upon opening.

Please help.

Thanks,
EVT123