Newbie - autorun a macro?

jillen04 · #1 (**permalink**) 02-09-09, 14:20

OK, I'm not really an Excel person, but I have created a macro that I want to run everytime the xls file is opened. Is there something like 'on startup' similar to Access?

TIA,
Joanne

jillen04 · #2 (**permalink**) 02-09-09, 14:32

Never mind...found This Workbook/OnOpen

myle · #3 (**permalink**) 02-09-09, 19:37

Sub Auto_OPen
...
...
End Sub

If you put this into a modules every time excel file open will exe it

Sub Auto_Close
...
...
End Sub

will get run when the excel file is closed

jillen04 · #4 (**permalink**) 02-10-09, 11:28

Thanks, MYLE

Internet Services

Web Development

Digital Marketing

Consumer Tech