Auto run a macro

[Guest]

Hi,

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

Br,
Jakob

 

[Zone]

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