|re: Is there a way to lock the original date, say after printing so that the original date of the invoice is always displayed?|
What if you don't print the invoice on the same day it is created?
The reason I ask is that you can force Excel to run a Macro immediately before the sheet is printed so you could lock in the date that way. However, if you created the invoice on the 1st but didn't print it, and then opened in on the 8th and printed it, a Before_Print macro would lock in the 8th.
You can also lock in the date before you save it, or as soon as you open it or as soon as you make a change to any other cell or even select another cell or...or...or...
Tell us when it's the best time(s?) to lock in the date and we'll see what we can offer.