Auto run macro

[Tinhare]

How do I make a macro run automaically when the workbook is opened?
I thought I knew how to this but hmmm, can't remember.

Thanks,
Alan.

[Ivan F Moala]

On 2002-05-03 00:51, Tinhare wrote:
How do I make a macro run automaically when the workbook is opened?
I thought I knew how to this but hmmm, can't remember.

Thanks,
Alan.

either

Placed in the Thisworkbook Object module

Private Sub Workbook_Open()

Call MymacroName

End Sub



Or

In A Std Module



Sub Auto_Open()



End sub