How to prevent date from changing

[BlackFireNova]

I am using a workbook to keep daily records of events. Each day I copy the 'blank' form which contains formatting, including one field which is simply =today() Once I have copied a sheet, and the date for that day has been calculated, I don't want it to change.

Can anyone suggest a better way to set a cell to automatically pick up that day's date, and then stay locked after that, so when the data is accessed on another day the date does not automatically change after it has been set the first go?

Thanks

[Mordred]

Have you tried pasting values only?

[FDibbins]

Instead of using the formula, todays date can be quickly inserted by using ctrl ; (semi-colon) This could be added to a macro that activates when the WB is opened, but then that would change to today's date whenever you open it again

[timtim89]

Untested, but try this one:

Please Login or Register  to view this content.