Automatically displaying a date

  • Thread starter Thread starter Tom
  • Start date Start date
You can use the following VBA code to have the date appear in cell B3 the first time you open the spreadsheet (and then never change on subsquent days/opennings). I use it for a template of a daily order recap form. (Just make sure the user doesn't save over the template ;

Private Sub Workbook_Open(
If Sheets("master").Range("b3") = "" The
Sheets("master").Range("b3") = Dat
Els
End I
End Sub
 
Back
Top