autoexec macro to run on opening the spreadsheet

[Guest]

How do I make a macro that starts automaticaly upon the file opening?

On other applications you could save the macro with the file name autoexec
and this would work, but how do you do this with Excel ???

 

[VBANoob]

Hi,

Press Alt + F11. Select this workbook then enter

Private Sub Workbook_Open()
'Your code here
End Sub

Link should help to

http://www.mcgimpsey.com/excel/modules.html

VBA Noob

 

[Guest]

Private Sub Workbook_Open()
'Opening
Your code here
End Sub
HTH
Lou