Excel autoexec macro

[cto]

Is there a way to create an autoexec macro that invokes each time a file is opened. This feature is available in Access but I can't seem to find any info on an Excel version.

[Juan Pablo González]

Do you mean excecute a macro each time ANY file is opened or one SPECIFIC file is opened ?

[cto]

I mean when a particular file is opened.

Thank you,

[Juan Pablo González]

Then, do this:

Open the workbook.
Right click on the little workbook icon next to the "File" menu and choose "View Code"

Select, from the first dropdown, "Workbook" and from the second one "Open".

Between these two lines

Private Sub Workbook_Open()

End Sub

You can put the macro you want to execute.

[y2k]

call the macro Auto_Open if you want it to execute when you open it. If you want it to execute when you close the file (such as to autmatically save changes) call it Auto_Close.