How to record macro to print pages modified today

P

pamiam3333

Is it possible to tell Excel to print pages that were modified today (within
a workbook)? Excel 2003
 
M

Myrna Larson

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.
 
Top