Worksheet activate
 

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

Worksheet activate
 

Where are you calling App_WorkbookOpen from

--
Message posted from http://www.ExcelForum.com

Worksheet activate
 

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

-----Original Message-----
Where are you calling App_WorkbookOpen from?


---
Message posted from http://www.ExcelForum.com/

.