Open workbook with the same sheet every time

[Guest]

Can someone provide me with the code I need for the following:
If, say, I've got three worksheets - 1, 2 and 3 - how do I get the workbook
to open with sheet 2 every time?
Thanks
Ed

 

[User]

Can someone provide me with the code I need for the following:
If, say, I've got three worksheets - 1, 2 and 3 - how do I get the workbook
to open with sheet 2 every time?
Thanks
Ed

Hi cavasta,

go to you workbook's open even and write the following code.

sheet2.activate

bye,

naweed

 

[Guest]

Thanks very much Naweed. That's just what I wanted.
Ed