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
<pre/>
Placed in the Thisworkbook Object module
Private Sub Workbook_Open()
Call MymacroName
End Sub

Or
In A Std Module

Sub Autpen()

End sub