Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clear Contents | Setting up and Configuration of Excel | |||
Clear Contents | Excel Discussion (Misc queries) | |||
Contents of range to move daily | Excel Discussion (Misc queries) | |||
Macro to clear range contents when cell contents are changed by us | Excel Programming | |||
Clear Contents Help | Excel Programming |