Cannot thank you guys enough. The solution posted by Mr. Peterson
achieves exactly what I was looking for, although the other code
provided would probably work just as well.

Thank you all so, so much !!!

Arsene

On Fri, 1 Oct 2010 12:03:41 -0700 (PDT), Don Guillett Excel MVP
wrote:

On Oct 1, 9:02*am, dksaluki wrote:
To go with Don's idea: *Is the url already in cell C1? *If so, this
would not even require a button.

Using the FollowHyperlink worksheet even handler:
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
Range("B1").Value = Date
End Sub

Good but OP wants date in cell to left so this works for any cell with
a hyperlink.
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
Cells(ActiveCell.Row, ActiveCell.Column - 1) = Date
End Sub