Automatically open on today's date across multiple pages

[theanythingtree]

Hi, Firstly I'll warn you, I'm quite the novice when it comes to VBA, here is what I've been trying to accomplish. I have a workbook that spans several sheets, I would like, upon opening the workbook to always make the cell with today's date the active cell. I can manage to get this to happen on one sheet with the following...

Please Login or Register  to view this content.

Can anyone help me so that all the sheets in my workbook are searched upon opening and the active cell will be the cell with today's date? In case it matters, the date will always be in column C, and the sheets will be named with the week of the year, starting on Mondays, for example...Dec 10, Dec 17, Dec 24, etc. Hopefully I've explained everything clearly, if not let me know and I'll be glad to clarify all I can. Thanks!

[AlphaFrog]

Please Login or Register  to view this content.

[theanythingtree]

Works like a charm. Thank you, so much, I've spent way too much time the past couple of days trying to figure this one out. I should have just asked.

[theanythingtree]

Sorry but, it seems like it will no longer make active today's date if you're on the sheet with today's date, if you're on another sheet it works like a charm. Any ideas?

[AlphaFrog]

Sorry but, it seems like it will no longer make active today's date if you're on the sheet with today's date, if you're on another sheet it works like a charm. Any ideas?

Works for me.
]
Do you have any other code, maybe a Selection_Change event procedure, that could select another cell? Otherwise, could you attach an example workbook?

[theanythingtree]

As far as I can tell there is no other code...I'll attach the workbook in question.

[AlphaFrog]

Try this...

Please Login or Register  to view this content.

[theanythingtree]

Close...now it makes the cell with today's date active, but it still doesn't move the screen to that cell...but only on the sheet with today's date, other sheets work perfect. Sorry for the trouble, this all seemed like it should be so simple when I started.

[AlphaFrog]

Please Login or Register  to view this content.

[theanythingtree]

Perfect!...You are a genius, a master, a miracle worker. I can't thank you enough.