current Date and time in cell
 

Further to my last post
http://www.excelforum.com/showthread...ight=show+time
Is it possible to show current date and time when sheet is opened
please?

thanks in advance

alex


--
Alex01
------------------------------------------------------------------------
Alex01's Profile: http://www.excelforum.com/member.php...o&userid=26311
View this thread: http://www.excelforum.com/showthread...hreadid=516280

current Date and time in cell
 

=now()
format as date and time.

This will update whenever excel recalculates.

Alex01 wrote:

Further to my last post
http://www.excelforum.com/showthread...ight=show+time
Is it possible to show current date and time when sheet is opened
please?

thanks in advance

alex

--
Alex01
------------------------------------------------------------------------
Alex01's Profile: http://www.excelforum.com/member.php...o&userid=26311
View this thread: http://www.excelforum.com/showthread...hreadid=516280

--

Dave Peterson

current Date and time in cell
 

Put the folowing macro in This Workbook code:


Private Sub Workbook_Open()
Sheets("Sheet1").Activate
Cells(1, 1).Formula = "=NOW()"
Cells(1, 1).Value = Cells(1, 1).Value
End Sub

Everytime you open the workbook, cell A1 in Sheet1 will be time/date marked.
--
Gary''s Student


"Alex01" wrote:


Further to my last post
http://www.excelforum.com/showthread...ight=show+time
Is it possible to show current date and time when sheet is opened
please?

thanks in advance

alex


--
Alex01
------------------------------------------------------------------------
Alex01's Profile: http://www.excelforum.com/member.php...o&userid=26311
View this thread: http://www.excelforum.com/showthread...hreadid=516280

current Date and time in cell
 

many thanks for your valued advice.

alex


--
Alex01
------------------------------------------------------------------------
Alex01's Profile: http://www.excelforum.com/member.php...o&userid=26311
View this thread: http://www.excelforum.com/showthread...hreadid=516280