| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How to record macro to print pages modified today
Is it possible to tell Excel to print pages that were modified today (within
a workbook)? Excel 2003 |
|
#2
|
|||
|
|||
|
Your first task is to decide how to identify the sheets that were modified
today. Perhaps a Worksheet_Change event macro that writes a date to a specific cell would suffice. Then, to print, you can loop through the sheets, look at that cell, and print if the date is correct. Of course you also need to decide how to clear that "flag" cell. On Fri, 9 Sep 2005 11:49:39 -0700, "pamiam3333" wrote: Is it possible to tell Excel to print pages that were modified today (within a workbook)? Excel 2003 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| record an excel macro, save on network so that everyone can access | Excel Discussion (Misc queries) | |||
| How do I record a macro which should work on multiple files ? | Excel Discussion (Misc queries) | |||
| Record new macro ghosted | Excel Discussion (Misc queries) | |||
| Record Macro Relative does not work? | Excel Discussion (Misc queries) | |||
| Record Macro Relative does not work? | Excel Discussion (Misc queries) | |||
Hybrid Mode
