I have created a simple macro that creates a time stamp on a specific
cell using the NOW() function. It works perfectly, but resets the
time/date each time I open the document.

Any help would be greatly appreciated.


Code Below:

Sub Time_Stamp()
'
' Time_Stamp Macro
'
Range("B11").Select
ActiveCell.FormulaR1C1 = "=NOW()"
Range("B12").Select

End Sub


--
justin4480
------------------------------------------------------------------------
justin4480's Profile: http://www.excelforum.com/member.php...o&userid=34907
View this thread: http://www.excelforum.com/showthread...hreadid=546465