autorun code when opening sheet (not workbook)
 

H

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

For instanc

If i click on "sheet2
Sheet 2 opens u

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

autorun code when opening sheet (not workbook)
 

Steve,

Use the Activate event of the worksheet. Right click on the sheet
tab and choose View Code. In the code module that opens up, use

Private Sub Worksheet_Activate()
' your code here
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Steve Mutambo" wrote in
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

autorun code when opening sheet (not workbook)
 

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
.

autorun code when opening sheet (not workbook)
 

You the man Chi
You the man
Thanks