Open workbook with the same sheet every time
 

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

Open workbook with the same sheet every time
 

On Jul 15, 2:08 pm, cavasta wrote:
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

Open workbook with the same sheet every time
 

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

"User" wrote:

Hi cavasta,

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

sheet2.activate

bye,

naweed