SetFocus on a different sheet in VBA

A

AaronC

In my workbook, I have 2 worksheets. Sheet2 contains the raw data.
Sheet1 is a summary level of the raw data containing many calculations,
formatting, etc.

I have VBA code that populates sheet2 with data from an external source
on the Workbook_Open event.

The last thing I want to do after populating the sheet is to set focus
(or activate?) a different worksheet, in this case, sheet1.

Can anyone tell me how to accompish this? I have searched Help till I'm
blue in the face and can't think any more possible keywords.

Any help is appreciated! Thanks!
 
J

JE McGimpsey

One way:

Private Sub Workbook_Open()
'Load Sheet2
Me.Sheets("Sheet1").Activate
End Sub
 
Top