hi
you could put the code in the ThisWorkbook Before close event. or even the
before save event.
open the vb editor (alt + F11). click your VBAProject(workbook). click This
Workbook. in the left dropdown over the code window, chick This Workbook. in
the right dropdown, scroll to before close. type or paste your code.

Regards,
FSt1

"Jimmy D" wrote:

I have a set of data sums which are updated from anther excel document daily
and I need to be able to record these figures to be able to work out how much
work has been done between yesterday and today.
Since this document will be a template for other users I would like to be
able to automatically run a macro on shutdown to copy the values from today
to another position so as to be able to use them tomorrow. The macro is
simple enough. My problem is how do I make it run with no input from the
user? But still give the user time to print a report prior to the macro
running.
--
Jimmy