Start a macro when click on tab sheet

[Nancy]

Hi,



When I click on a tabsheet to open a sheet I would like that automaticly
u=one macro start to update this sheet.
It is possible?
Thank you in advance

Nancy

 

[Guest]

Paste this into the worksheet module
Private Sub Worksheet_Activate()
MsgBox "start to update this sheet"
End Sub

 

[Jean]

Paste this into the worksheet module
Private Sub Worksheet_Activate()
MsgBox "start to update this sheet"
End Sub

I try it but nothing happens!

Nancy

 

[Gary Keramidas]

put the code on the sheet that is activated when you click the tab,
for example, if you want the code to fire when you click on sheet2
then in the vb editor, double click sheet2 under ms excel objects and paste his
code there.

Private Sub Worksheet_Activate()
MsgBox "start to update this sheet"
End Sub

 

[Gord Dibben]

Jean

Where did you place the code?

Right-click on the sheet tab and "View Code"

Copy/paste the code into that sheet module.

Switch to another sheet then back to first sheet to "Activate" the code.


Gord Dibben MS Excel MVP