Macro to hide rows based on today's date and auto run it

[evt123]

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

[Solus Rankin]

Please Login or Register  to view this content.

Change the name of the sheet to the one you want it to run on.

[evt123]

Solus,

Thanks for the reply. This is my first experience with VBA, so forgive me if I'm doing something wrong. I opened the developer tab and pasted in your code. Then, I changed "SheetYouPick" to the name of my worksheet, per your instructions. I saved the workbook as a macro enabled workbook. Then, I closed the workbook, reopened it and the old dates that I expected to be hidden, were still there. What did I do wrong?

Any ideas? Thanks for your help.

EVT123

[JOHN H. DAVIS]

Another:

Please Login or Register  to view this content.

[Solus Rankin]

evt123,

Did you save it in the workbook module? Double click ThisWorkbook shown in this picture to insert the code.

Capture.PNG

[evt123]

Solus,

Thanks. That was what I did wrong. Much appreciated!

EVT123

[Solus Rankin]

Glad to help. And welcome to the forum.

If you are happy with the solution please mark the thread as [SOLVED] using the thread tools at the top.

And on any thread you can show your appreciation to those who have helped you by clicking the * below their post.