LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Running a macro from an auto-refresh Chris Youlden Excel Worksheet Functions 2 October 7th 07 04:22 PM
Excel still running in task manager after closing the application Willem Excel Discussion (Misc queries) 0 December 5th 06 01:56 PM
macro closing worksheet Jeff Excel Discussion (Misc queries) 1 July 3rd 06 01:58 PM
Help with auto macro on closing mr_teacher Excel Discussion (Misc queries) 3 May 17th 06 01:07 PM
Auto Save on closing AJM1949 Excel Discussion (Misc queries) 3 September 21st 05 10:03 AM


All times are GMT +1. The time now is 12:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"