<p>I'm building an excel template (*.xlt) for a user here, and one of the things I want to do is have it insert the current date when a new document is created (ie, when they double-click the file in windows explorer).  How do I do this?</p>

<p><strong>Update:</strong> I should have added that I would prefer not to use any vba (macro).  If that's the only option, then so be it, but I'd really like to avoid forcing my user to remember to click some 'allow macro content' button.</p>

You can edit the default template for excel -
There is a file called
```
Book.xlt
```
in the
```
XLSTART
```
directory, normally located at
```
C:\Program Files\Microsoft Office\Office\XLStart\
```
You should be able to add a macro called Workbook_Open
```
```
Private Sub Workbook_Open()
    If ActiveWorkBook.Sheets(1).Range("A1") = "" Then
        ActiveWorkBook.Sheets(1).Range("A1") = Now
    End If
End Sub
```
```
My VBA is a little rusty, but you might find something like this works.