Amy

See John McGimpsey's site for a non VBA approach using a circular reference.

http://www.mcgimpsey.com/excel/timestamp.html

Would your users object to having event code add a static date when the workbook
is opened?

Is your template a true template file? As in template.xlt?

You could add this code to Thisworkbook module in your Template.xlt file

Private Sub Workbook_Open()
With Sheets("Sheet1").Range("A1")
If .Value = "" Then
.Value = Format(Now, "ddmmmyy")
End If
End With
End Sub

Whenever a new book is created from your template, the date will be entered in
A1 of Sheet1.

When you save that book as template1.xls, the date will be frozen.


Gord

On Wed, 23 Jan 2008 14:35:01 -0800, Amy wrote:

Thanks, but is there a formula that I can use so the users of my template
never have to enter a date?

AS

"Gord Dibben" wrote:

Yes.

OR enter the date using CTRL + semi-colon to get a static date.

OR code the date as static when you save the file.


Gord Dibben MS Excel MVP

On Wed, 23 Jan 2008 12:56:00 -0800, Amy wrote:

If I use this in a template, how can I get it to save the correct day's date
each time? Do I have to copy, paste special - values?