Worksheet activate

[Lee Hunter]

Follwing is part of some code I'm using. The worksheet
activate is not invoked when it's workbook is open, but
is invoked when it is manually activated. That is, when
I activate another sheet and then activate sheet 2 again.

What am I overlooking?

Thanks!

Private Sub App_WorkbookOpen(ByVal Wb As Workbook)
Worksheets("sheet2").Activate
End Sub
Private Sub Worksheet_Activate()
Dim MyRange, answer, mess, startR As Range, endR As
Range, MRange As Range
Set MyRange = Range("a7")
MyRange.Select

 

[E_R]

Where are you calling App_WorkbookOpen from

 

[Guest]

From this link I understood that this event was triggered
by just opening the workbook. Not Correct?

http://support.microsoft.com/default.aspx?scid=kb;en-
us;213220&Product=vba