MACRO

  • Thread starter Thread starter Neil Holden
  • Start date Start date
N

Neil Holden

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.
 
Neil,

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

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

Mike
 
Back
Top