Macro autorunning

P

pjotr

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

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
 
Top