Macro autorunning

[Guest]

Hi
How can I get a certain macro run automaticly when selectin a certain
worksheet?
(excel 2003)
rgds, Pekka

 

[Don Guillett]

Right click on the worksheet tab>view code>left window select
worksheet>right window select activate.

 

[Guest]

Thanks Don but still I have the same problem. The Macro (sub test()) do not
run automatically when selecting sheet2 unless I put put the macro in the
sheet2 VBA-area. What did I do wrong?
Pjotr

"Don Guillett" kirjoitti:

 

[Gord Dibben]

Pekka

Right-click on the sheet tab and "view code"

Copy/paste this into the module.

Private Sub Worksheet_Activate()
your_macro_name
End Sub

Gord Dibben Excel MVP

 

[Don Guillett]

That's where to put it to have it run when you activate THAT sheet.

 

[Guest]

Thanks Gord. now it works

"Gord Dibben" kirjoitti: