MrExcel Publishing
Your One Stop for Excel Tips & Solutions

System enter & lock today's date without user input or VBA


Posted by Jim on February 01, 2002 5:57 AM

Trying this again, no takers yesterday. Without VBA, is it possible to have a cell that shows today's date, locked as a static value, all without user input?


Posted by john on February 01, 2002 6:14 AM

Just enter =today() as a formula

John

Posted by Jim on February 01, 2002 6:29 AM

Won't work, tomorrow it shows tomorrow

Won't work here, tomorrow it will show tomorrow's date. Once entered (by system, not user), I don't want it to change.

Posted by DK on February 01, 2002 6:43 AM

I will happily give a tenner (about $15) to anyone who can do this without VBA, as I'm that certain it can't be done with just formulae.

Please, some clever sod prove me wrong! :-)))

D

Posted by Benny on February 01, 2002 6:53 AM

Chicken or the Egg?

**** I like a good challenge, but what dates should first appear in the cell? Will the date ever need to be changed?

As a side note, you can quickly enter the current date as a value by pressing CTRL+; Still, that requires user input.

Posted by Jim on February 01, 2002 7:19 AM

Re: Chicken or the Egg?

Should have said this is for a template. When a new file is created based on this template, the date it is created would automatically populate the cell and become locked or a static value from that point forward. **** I like a good challenge, but what dates should first appear in the cell? Will the date ever need to be changed? As a side note, you can quickly enter the current date as a value by pressing CTRL+; Still, that requires user input.

Posted by lucky on February 01, 2002 8:29 AM

Re: Won't work, tomorrow it shows tomorrow

Why do it with out VBA?
You could have a macro that runs when the new template is opened to permanently record the date......

Posted by Jim on February 01, 2002 1:40 PM

No choice, SYSOP says no VBA

With VBA it would be a no brainer but this is for a group running Excel over a network with users spread over the US. The IT folks don't want any VBA code running around to potentially spread germs or viruses. Can't convince them otherwise. Why do it with out VBA?