Excel Fix Auto Date 2

[Hakala]

Hi, Tek-Tippers!

I have a worksheet in Excel 2002 which has a date field that autofills with today's date. We use this as a form, and the users were often forgetting to update the date, so we autofilled it.

The trouble is, it autofills every time the sheet is opened.

What I need is a sheet that autofills today's date when it's opened the first time, and then fixes that date when the sheet is saved with another name.

Any ideas?

Michelle Hakala

http://www.winebird.com/

 

[AnotherHiggins]

The only way to automate this will be with VBA.

Please repost your question in forum707.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[SkipVought]

Hi Michelle,

This cannot be done with native Excel. It takes VBA (macro) code.

If you wish to pursue, and it's not really very difficult, please post your question in Forum707. You might also record a macro, using Tools > Macro > Record new macro... where you would COPY the column containing the Dates and then Edit > Paste Special -- VALUES. Turn off the macro recorder and copy you recorded code and paste it along with your question.

Skip,

_{Just traded in my old subtlety...
for a brand NUANCE!}

 

[Hakala]

Thank you for redirecting me to the proper forum. It worked!

Michelle Hakala

http://www.winebird.com/