View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jimmy D Jimmy D is offline
external usenet poster
 
Posts: 9
Default Auto running a macro on closing

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