Worksheet Activation from another workbook
 

Worksheet_Activate() works great from within a workbook. But when I switch
workbooks and come back, the code in Worksheet_Activate() does not run.

What do I need to do to get the code to run when re-entering from another
workbook?

As always, any help is always appreciated.

Worksheet Activation from another workbook
 

That is because it is already active within that workbook.

Add some code to the Workbook_Activate event in the ThisWorkbook code
module.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Ronbo" wrote in message
...
Worksheet_Activate() works great from within a workbook. But when I
switch
workbooks and come back, the code in Worksheet_Activate() does not run.

What do I need to do to get the code to run when re-entering from another
workbook?

As always, any help is always appreciated.

Worksheet Activation from another workbook
 

Maybe you could use Workbook_activate (under thisworkbook). But that doesn't
apply if you're changing applications.



Ronbo wrote:

Worksheet_Activate() works great from within a workbook. But when I switch
workbooks and come back, the code in Worksheet_Activate() does not run.

What do I need to do to get the code to run when re-entering from another
workbook?

As always, any help is always appreciated.

--

Dave Peterson

Worksheet Activation from another workbook
 

Thanks to both - Thats what I should have been doing from the start, rater
than putting code in each sheet. DA!

"Bob Phillips" wrote:

That is because it is already active within that workbook.

Add some code to the Workbook_Activate event in the ThisWorkbook code
module.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Ronbo" wrote in message
...
Worksheet_Activate() works great from within a workbook. But when I
switch
workbooks and come back, the code in Worksheet_Activate() does not run.

What do I need to do to get the code to run when re-entering from another
workbook?

As always, any help is always appreciated.