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
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
=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
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
>
>
many thanks for your valued advice.
alex
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks