current Date and time in cell

[Alex01]

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

[Dave Peterson]

=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

[Gary''s Student]

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
>
>

[Alex01]

many thanks for your valued advice.

alex