It appears your are correct. Using both the before save and the before
print events concurrently is the way to go to update the revision date
only once.

However, I need help with the code when the worksheet has not been
changed, I want it to keep the same revision date of the last change.
In other words,

(1) I may accidently save again when there have been no changes
(2) I may want to merely print the worksheet without making any
changes
In either case, I need the worksheet to retain the date of the last
change.

Can you help? MikeBurg


--
mikeburg
------------------------------------------------------------------------
mikeburg's Profile: http://www.excelforum.com/member.php...o&userid=24581
View this thread: http://www.excelforum.com/showthread...hreadid=395970