Merevyn,

Name the macros Auto_Open and Auto_Close.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Mervyn Thomas" wrote in message
...
I know its there somewhere but I cannot find help on how to run
a macro
which runs automatically when a workbook is opened and again how
to run a
macro when a workbook is closed.
I can't figure out how to run open and close events!
Can anyone get me started?