Vba to activate when click on sheet

[Throughstream]

Hi I have a click vba button but is it possible for it to activate just when I click a specific sheet rather than needing click button itself .
Thanks in advance

[Raphaelp]

Put this in the code sheet of the worksheet you want (NOT in a regular module)

Please Login or Register  to view this content.

[gmr4evr1]

Yes, with Worksheet_Activate event.
Place the code in the worksheet you want the code to run on when activated and change the title of the sub to
Private Sub Worksheet_Activate()

[Throughstream]

thank you both so much

[gmr4evr1]

You're welcome. Glad it worked for you.