How can today's date in Excel - in a FORM - be saved as the day the form was accessed and filled in?

I've created a form and I want to 'lock' the date - set up automatically for 'today' - so that when the form (template) is 'saved as' for a specific project, the date the form was originally saved is saved, i.e. it doesn't KEEP returning the 'today' date.


Is this clear? or have I clouded it?


I select a form to input data on, e.g. 12/24/2008, I add the data and then save the form in the project file.


The next person in the chain retrieves the form a couple of weeks later and the submission date, i.e. 12/24/2008 is still showing.


What I'm trying to do is stop people 'back dating' a form by having the form automatically add today's date, but then I want the date SAVED in the cell on the date it was originally processed


Anyone got any ideas please?


Many thanks


Pooo

How can today's date in Excel - in a FORM - be saved as the day the form was accessed and filled in?
You have to learn how to write vba for that.





Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)


ActiveSheet.Range("a1") = Now()


End Sub