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.