Run When Open Macro

[T.R.]

I am looking for a Macro to tell another Macro to run
automatically whenever I open an Excel workbook.

Thanks for the help.

T.R.

 

[Ron de Bruin]

Hi T.R

Two ways

Sub Auto_open()
'code or macro name
End Sub

Copy in a normal module
If you use a Auto_open macro then this wil not run if you open the file with a macro


Private Sub Workbook_Open()
'code or macro name
End Sub

Copy in the Thisworkbook module