Right-click the worksheet tab and select "View Code". This will open the
code module for that worksheet only. Above the code area are 2 drop-down
arrows General & Declarations. Click on General arrow and select Worksheet.
Now the right down arrow will give a list of Worksheet Events you can write
code for.

Mike F
"Guye" wrote in message
ups.com...
Hi,
I have written 2 seperate codes for 2 different worksheets.
and i would like to apply each of them only on the relevant worksheet,
both codes a

Private Sub Worksheet_Activate

how can i apply each code only for 1 worksheet ?

thanks