LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default Clear Contents at 5PM daily

Hi, I need a macro to run at 5 pm daily to clear out the days notes on a
shared workbook. Each worker has a notation page, cell B6. All of them are
B6, all B6 cells except for the front page called "Note Tracker" need
cleared. Should I run an OnTime macro to clear these, and how do i set it
for a clock time rather than a delay interval. Also, If no one is using this
program at the time, will these clear. I need it to clear even if no one is
accessing the program at the time, when it is on the server. Should this
Macro be put under General or should it be on each sheet?
 
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
Clear Contents gibbylinks Setting up and Configuration of Excel 5 October 12th 09 05:04 PM
Clear Contents Secret Squirrel Excel Discussion (Misc queries) 1 February 3rd 09 12:37 AM
Contents of range to move daily David P. Excel Discussion (Misc queries) 11 March 30th 07 01:44 AM
Macro to clear range contents when cell contents are changed by us Steve E Excel Programming 12 February 22nd 07 09:09 PM
Clear Contents Help michael Excel Programming 3 June 6th 06 09:42 PM


All times are GMT +1. The time now is 01:00 PM.

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

About Us

"It's about Microsoft Excel"