Neil,

Put this line in your code and it will be a static date/time

Sheets("sheet2").Range("A1") = Now

Mike

"Neil Holden" wrote:

Hello, I have a working macro that enables users to submit a proposal, What i
need now is when the user clicks submit i need another excel sheet to pull
the frozen date so that I know exactly when the excel sheets have been
submitted.

Thanks.