It would take a little experimenting to see if it worked right, but it seems
like a custom "Before-Print" macro ought to do the job. Or maybe special
"Print" buttons on each sheet to run macros that changes the date before
printing the sheet.

Vaya con Dios,
Chuck, CABGx3



"Sam" wrote in message
...
I have a timesheet spreadsheet with worksheets for each day. I want the
date
that a specific worksheet (e.g., Tuesday) is printed and don't want that
date
to change on the worksheet until/unless that specific worksheet is printed
again. Each worksheet could/should have a different print date. Using
header/footer shows the date it is printed, but changes each day. Is
there a
way to do this?