hi.
put your macro in the workbooks on open event.
when the workbooks is opened, the macro runs.
:o
-----Original Message-----
....
.