Run When Open Macro

T

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.
 
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
 
Top