Worksheet_Activate () - Need to work when any worksheet is activated

Hi All,

I have this code sitting in Sheet2 of my workbook:

Please Login or Register  to view this content.

The code kicks in when I activate sheet2 (that is where I want the code to work), but what I need is for the code to update sheet2 whenever any of my worksheets are activated. Help...?

JM

Hi there,

Insert the following code into the "ThisWorkbook" VBA CodeModule:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

Hi Greg,

That worked perfectly, but it threw up an unexpected problem, because the code causes a small load time now every time I select a new tab, timings are building up - so could I ask you this: Instead of before when I wanted the code to kick in when any worksheet, can I have it kick in only when I select sheet3?

Regards,
JM

Hi again Jim,

You can speed up the execution of the routine a little bit by adding the highlighted statements:

Please Login or Register  to view this content.

Or you could just change the first line of the routine to:

Please Login or Register  to view this content.

then insert the routine into the VBA CodeModule for Sheet 3, and delete it from the CodeModule for ThisWorkbook.

And of course, you can even enter the "speeded-up" routine into just the CodeModule for Sheet 3.

Hope this helps - please let me know how you get on.

Regards,

Greg M