assign the following two-liner to a button and use it for any cell,
rather than a button for each cell:

Sub refresh_date()
Dim sDate As String
ActiveCell.Value = Format(Now(), "yyyy-mmm-dd")

End Sub


--
protonLeah
------------------------------------------------------------------------
protonLeah's Profile: http://www.excelforum.com/member.php...o&userid=32097
View this thread: http://www.excelforum.com/showthread...hreadid=523341