how about using the workbook's OPEN event to revise the last edited date?

"Still_learning" wrote in message
...
Hi,

I know by using a before save event you can update the revised date. The
revised date is held in the left footer.

Is there a way to have the before save event placed some where, so that
any
workbook opened (new or old) would trigger the event but would update the
revised date in only the workbook that was being saved.