View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
MilleniumPro MilleniumPro is offline
external usenet poster
 
Posts: 6
Default Static Date and Time in Excel 2007

Hello all,

I have googled around and have not been able to find the answer on the
following:

I am looking to have a cell that automatically populates the current date
and time and leave that information STATIC in that cell once populated when
an adjacent cell has a value entered into it. The only answers I fould were
for excel 2000 and 2003. I am using 2007 and I am totally lost with the new
menu system that has been implemented here. If this requires a macro, please
help me walk through how to enter the area where the macros is to be enter
along with any supporting code. Thanks to anyone in advance that can help.