sheet event wait for another event?
Is there a way to sleep the activate event, and wait for the hyperlink event to finish?
I tried this and .. no go
Dim newHour As Variant: newHour = Hour(Now())
Dim newMinute As Variant: newMinute = Minute(Now())
Dim newSecond As Variant: newSecond = Second(Now()) + 5
Dim waitTime As Variant: waitTime = TimeSerial(newHour, newMinute, newSecond)
Application.Wait waitTime
|