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