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.

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.

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

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.