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

Justin4480, try this

Sub Time_Stamp()
'
' Time_Stamp Macro
'
Range("B11") = Now

End Sub


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"justin4480" wrote
in message ...

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

Perfect.

Thanks Paul


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

Your welcome

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"justin4480" wrote
in message ...

Perfect.

Thanks Paul


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