how do i insert todays date in a spread sheet just prior to print
 

wish to have excel automatically add date to same cell in spread sheet every
time it is opened.

how do i insert todays date in a spread sheet just prior to print
 

hi,

enter the formula

=today()

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"wayne h" wrote:

wish to have excel automatically add date to same cell in spread sheet every
time it is opened.

how do i insert todays date in a spread sheet just prior to print
 

Your body description is at odds with your subject line.

Which is correct?

Before Printing or when workbook is opened?

You choose.

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Sheets("Sheet1").Range("A1").Value = Format(Date, "mm-dd-yyyy")
End Sub

Private Sub Workbook_Open()
Sheets("Sheet1").Range("A1").Value = Format(Date, "mm-dd-yyyy")
End Sub


Gord Dibben MS Excel MVP

On Tue, 25 May 2010 10:39:01 -0700, wayne h <wayne
wrote:

wish to have excel automatically add date to same cell in spread sheet every
time it is opened.