software

Further to my last post
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: www.excelforum.com/member.php...oamp;userid=26311
View this thread: www.excelforum.com/showthread...hreadid=516280=now()
format as date and time.

This will update whenever excel recalculates.

Alex01 wrote:
gt;
gt; Further to my last post
gt; www.excelforum.com/showthread...ight=show time
gt; Is it possible to show current date and time when sheet is opened
gt; please?
gt;
gt; thanks in advance
gt;
gt; alex
gt;
gt; --
gt; Alex01
gt; ------------------------------------------------------------------------
gt; Alex01's Profile: www.excelforum.com/member.php...oamp;userid=26311
gt; View this thread: www.excelforum.com/showthread...hreadid=516280

--

Dave Peterson

Put the folowing macro in This Workbook code:Private Sub Workbook_Open()
Sheets(quot;Sheet1quot;).Activate
Cells(1, 1).Formula = quot;=NOW()quot;
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 Studentquot;Alex01quot; wrote:

gt;
gt; Further to my last post
gt; www.excelforum.com/showthread...ight=show time
gt; Is it possible to show current date and time when sheet is opened
gt; please?
gt;
gt; thanks in advance
gt;
gt; alex
gt;
gt;
gt; --
gt; Alex01
gt; ------------------------------------------------------------------------
gt; Alex01's Profile: www.excelforum.com/member.php...oamp;userid=26311
gt; View this thread: www.excelforum.com/showthread...hreadid=516280
gt;
gt;


many thanks for your valued advice.

alex--
Alex01
------------------------------------------------------------------------
Alex01's Profile: www.excelforum.com/member.php...oamp;userid=26311
View this thread: www.excelforum.com/showthread...hreadid=516280