Steve,

you need to put your code in the Activate event of the
worksheet. To do this from the VBE, double click on the
relevant sheet in the Project Explorer window,
select "Worksheet" from the first dropdown and "Activate"
from the second.

Insert the required code.

Cheers, Pete.


-----Original Message-----
Hi

I have a code that I want to use... but automaticalled
when one enters a sheet. How do i do this?

For instance

If i click on "sheet2"
Sheet 2 opens up

I want it so that If i click on sheet2 (open sheet2)
that a code of my choosing will automatically run for
that sheet.

Thanks,
Steve Mutambo
.