automatically open hyperlink at a certain day and time

[dougbitt]

How can I get excel to open hyperlinks at a certain time and day automatically?

 

[ranman256]

when you start the clock code: Recalc
it will put curr time in A1
put your trigger time in A2
and you link to open in A3


a1 = 10:55:10 AM curr time
a2 = 10:56 AM target Time
a3 = www.google.com link

Dim SchedRecalc As Date
Dim mvTargTime As Date, mvCurrTime As Date


Sub Recalc()

With Sheet1.Range("A1")
.Value = Format(Time, "hh:mm:ss AM/PM")
End With

Call SetTime

mvTargTime = Range("A2")
mvCurrTime = Range("A1")

If mvCurrTime = mvTargTime Then ActiveSheet.Range("A3").Hyperlinks(1).Follow

End Sub

Sub SetTime()
SchedRecalc = Now + TimeValue("00:00:01")
Application.OnTime SchedRecalc, "Recalc"

End Sub

Sub Disable()
On Error Resume Next

Application.OnTime EarliestTime:=SchedRecalc, Procedure:="Recalc", Schedule:=False
End Sub