I am trying to make a macro work when a clock count down to zero. I have a
macro that is working when I am in some way activate the worksheet. How can I
activate the worksheet without doing a manual thing in it. I have a clock
running in the worksheet.
My macro looks like this:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Select Case Range("E29")
Case Is = 1
Range("E30").Select (This doesn´t happen before I do something
in the
End Select worksheet)

End Sub