Opening file to certain worksheet

[windme]

Hello All,

Using Excel 2007.

I have a workbook that has worksheets in a format of mmmdd (ex Jul04). Each of the tabs contain the end dates of bi-weekly reports. When I open the workbook I would like it to open to the worksheet that has the date that falls before the end date of the worksheet tabs.

I have attached a picture file that shows some of the tabs (worksheets) on the bottom. When I open the file I would like it to go to the Aug01 worksheet and highlight it red. (Jul21 is before the Aug01 tab but after the Jul18 tab).

Any help in making the code to do this would be appreciated.

Mike

[upperco]

If I am readng your question right, save the file on the worksheet you want it opened to. Next time you open it - it will open to that worksheet.

Next week, save the file in the following week's worksheet and it will open up there.

[windme]

This worksheet I made up for someone at my work.

Besides the 26 bi weekly tabs Ii also have 100 other worksheets with people names on them. Sometimes the worksheet would be saved going to one of these tabs, so the next time it is open it will find the right date and open up that workout plus color code the tab.

I have some code that works with a certain date:

Private Sub Workbook_Open()
On Error Resume Next
On Error GoTo 0
Sheets(Format(Date - 1, "mmmdd")).Activate
ActiveSheet.Tab.ColorIndex = 3
On Error GoTo 0
Range("A2").Select

End Sub

I need code like that but the date would be a 14 day period.

[shg]

windme,

Please read the Forum Rules and then wrap your code with Code Tags.

[windme]

Please Login or Register  to view this content.