Help with a Private Sub Workbook_Open

Hi,

I am trying to get a code to work:

Please Login or Register  to view this content.

What I'm trying to get it to do is if the date appears in Column 2 of the workbook "Rota" for the code to then Select the cell of the match of Extract 2 R1 in Rota column 1 and if the date isnt in Column 2 to do nothing

I'm thinking:

Please Login or Register  to view this content.

is wrong and i might need and "Else Goto" somewhenre in there.

Thanks in advance. John

Hi Holger, this is what I had before but because the way my file works I wanted it to open on the week that contained the date so I changed it where it looks at cell that contains the Week number as the week number is in column A. The problem is, as the file is being future proofed, lets say this week is Week 39 of the year, but its being used for next years rota it opens on Week 39 every time I open next years book. I am making this for other people to use and I dont want to disable the code then re-enable when next year starts

Hi Holger - Thanks for taking the time to respond

I have attached an example of the layout I'm dealing with: Copy of EF909993.xlsm

This is the code I had before:

Please Login or Register  to view this content.

This works in that if I open the book today it will go to "Week 39" as today is in Week 39 - but because I am opening next years file I dont want it to go to Week 39 and want it to do nothing. Hope this makes sense in what I'm trying to get to do. Its the same file that is going to be used for all future years and this year (as the dates in the actual file actually from the Data sheet anyway as that data is imported from a UNIX based data extract that is emailed to the user in a txt file and then is pasted into the Data tab. I'm trying to make it easy in that I can have 1 master file for all years and dont have to change/turn off code every year for ever user of this file!

Thanks

John

Hi Holger,

Please have a look at the updated file - when you press the button it goes to Week 39. I dont want it to unless today's date is in Column B of Rota. So next year on 26/03 when I open the Rota it will!

Cheers

John

Thats what I was trying to figure out in the code in the first post:

Please Login or Register  to view this content.

The underlined bit it the bit I think is wrong and needed help with.

Thanks

John

Thanks once again Holger - worked fantastic.