Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why wouldn't calling the Activate sub for a sheet automatically call that sheet's Worksheet_Activate() sub?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calling name of Sheet as a Variable? | Excel Worksheet Functions | |||
Calling a macro from Worksheet--Activate | Excel Discussion (Misc queries) | |||
can i call the ukraine on a prepaid calling card | Excel Discussion (Misc queries) | |||
how can i call a sub() automatically when someone click on sheet1 | Excel Worksheet Functions | |||
Automation Procedure with Worksheet_Activate | Excel Programming |