You can using the Workbook Open event. Set the security level to low/medium
in (Tools|Macro|Security). From workbook press Alt+F11 to launch VBE (Visual
Basic Editor). From the left treeview search for the workbook name and click
on + to expand it. Within that you should see the following

VBAProject(Your_Filename)
Microsoft Excel Objects
Sheet1(Sheet1)
Sheet2(Sheet2)
Sheet3(Sheet3)
This Workbook

Double click 'This WorkBook' and paste the below code to the right code pane.

Private Sub Workbook_Open()
Worksheets("Sheet1").Range("A1") = Date
End Sub

If this post helps click Yes
---------------
Jacob Skaria


"paankadu" wrote:

How do I get the date to remain static when a sheet is saved and not change
to the current date when it is re opened. It is a daily log and each shift
it will be opened to update. I would like the date to autopopulate the
current date but when it is saved it needs to remain that date. Each shift
will be saving the file under a new name. When they reopen the master it
needs to put the next current date in.

The users won't know to do the ctrl keys to make the date static. I need to
make it as automated as I can.

Thanks in advance for your assistance.
--
Thanks,
Angie