View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
newguyA14 newguyA14 is offline
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?