As long as you Worksheet_Activate in the appropriate worksheet code modules,
and not Workbook_SheetACtivate in ThisWorkbook code module, they will only
act upon the activation of that single sheet, and will not interfere with
each other (unless your code triggers the other of course).

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"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