I'm encountering the strangest thing, and I'm trying to figure out why it's
doing what it's doing.


Basically, my application is a VBA app, written in Excel 2002. In the
"ThisWorkbook.Workbook_Open" sub, there is a line that activates the first
tab. The line of code looks like this:

shtStart.Activate

Where shtStart is the name of the worksheet in question.


Within that worksheet's VBA code, there is the WorkSheet_Activate() sub, and
code within it.


But it seems that when the shtStart.Activate in the Workbook_Open sub is
called, it's not then (automatically) calling the WorkSheet_Activate() in
shtStart. I've even put break-points in the WorkSheet_Activate() sub, and
then ran the Workbook_Open sub (one line at a time), and still not hitting
the WorkSheet_Activate() sub.


What am I missing? Any ideas/suggestions?


Thanks!
-Scott