Can a macro be run on opening the file?

[Cortez]

Does anyone know if you can create a macro that is initiated when the
file is opened? I have a number of users that will need to work with
an original (master) document. I want them to open the master file,
and have a macro save the file as a new unique spreadsheet. I know
how to do what I need from a macro, but I would like to have the macro
run without being keyed in by the user.

Any ideas?

Thanks,
TK

 

[Dave Peterson]

Put the macro in a General module (not under ThisWorkbook and not under a
worksheet).

Name it:
Sub Auto_Open()

It'll run each time excel opens the file--if the user allows macros to run.

 

[Guest]

Yes! See the following Microsoft web page:
http://office.microsoft.com/en-us/excel/HA010346281033.aspx

 

[Cortez]

Yes! See the following Microsoft web page:http://office.microsoft.com/en-us/excel/HA010346281033.aspx

Thanks Lauren and Dave. Exactly what I needed.

TK