another date question

[micfly]

I'm trying to show todays date is N38 when the workbook is first opened.

I tried:
Private Sub OnOpen()
Range("N38").Value = Format(Now(), "mm-dd-yy hh:mm")
End Sub

Which wiorks fine but I want to be able to change the date is N38 and have it go back to todays date when the workbook is re-opened.

As of now, when I open it todays date is in there. If I change the date and close the book and re-open it the date I entered manually is still there. I want it to always show todays date when the workbook is first opened but can be changed after the book is opened. hope that makes sense.

 

[buxtongt]

Try:

=today()

it sounds like that will do what you need it to.

 

[micfly]

Try:

=today()

Where would I put that?

 

[micfly]

This worked:

Private Sub Workbook_Open()
Sheets("Sheet1").Range("N38").Value = Format(Now(), "mm-dd-yy hh:mm")
End Sub