Automatic Macro

[loo]

How do I have a macro run automatically when a workbook is opened?

 

[LSTAN]

Hi loo

Put the intended code in the Workbook activate event

Private Sub Workbook_Activate()
'
'your code here
'
End Sub

another alternative is have a Autpen procedure in a module

Sub Autpen()
'
'your code here
'
End Sub

Rgrds
LSTAN

 

[loo]

I found it...
name the macro
Macro_open
and it runs on open...
too simple

 

[loo]

oops Auto_open