View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
pjotr pjotr is offline
external usenet poster
 
Posts: 4
Default Macro autorunning

Thanks Gord. now it works

"Gord Dibben" kirjoitti:

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

On Sun, 8 Aug 2004 10:33:02 -0700, "pjotr"
wrote:

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