Newbie - Forcing Excel to open to specifc sheet or cell

[star99uk]

Hi

i'm new to this forum, i have what i think is a similar problem but you might thinks it's not

i have one file that is updated on different sheets each week and at the moment it opens to sheet 1 but i want it to open say sheet 6 this week then sheet 7 next week what's the best way to do this?

i also have a file that is updated daily but on the same sheet and it opens against A1 but i want it to open to that days cells for for example AA1 today but AF1 tomorrow again what's the best way to do this?

thanks in advance

[martindwilson]

to open to last sheet
put this in the workbook module

Please Login or Register  to view this content.

see link where does code go in my signature

[star99uk]

thanks for your help, it worked