Running macro on open of workbook?

Hello,
How do I set up a macro within a workbook to run when it opens, and when the
macro is done running a message box saying Macro Finished?

Any help??
Lime