Auto run a macro
 

Hi,

Can anyone please tell me how to run a macro automatically from the
VB-editor when opening the spreadsheet ?

Br,
Jakob

Auto run a macro
 

You can put this in the workbook module:

Private Sub Workbook_Open()
'your code here
End Sub

or you can put this in a standard module:

Sub Auto_open()
'your code here
End Sub

"Jayjay" wrote in message
...
Hi,

Can anyone please tell me how to run a macro automatically from the
VB-editor when opening the spreadsheet ?

Br,
Jakob