Worksheets("Sheet2").Activate
Worksheets("Sheet1").Activate

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Tim Coddington" wrote in message
...
Uh. I mean Worksheets("Sheet1").Activate would be the way to go.
"Tim Coddington" wrote in message
...
Because if the sheet is already active when the workbook opens,
Worksheet_Activate won't fire. Otherwise, Sheet(1).activate would be
the
way to go.

"Bob Phillips" wrote in message
...
Why not just activate the sheet from Workbook_Open?

Worksheets("Sheet1").Activate

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Tim Coddington" wrote in message
...
Stupid question time ...

How can I get the Worksheet_Activatecode (for sheet1) to activate
from
Workbook_Open() (even if sheet1 is already active)?
I tried just sticking the Worksheet_Activate command in
Workbook_Open(),
but
that doesn't seem to be accessable from Workbook_Open().