Flashing Cell With VBAOct 12, 2007
I originally posted this question with out the code I'm using. I am trying to make a specific cell flash to catch the attention of other dispatchers. The problem is when I we try to close the active page it will automatically open. The only way we can completely close the page is to close Excel completely. Doing this though also closes several other pages that we need to have remaining open.
Public NextFlash As Double
Public Const FR As String = "B3"
If Range(FR).Interior.ColorIndex = 3 Then
Range(FR).Interior.ColorIndex = x1ColorIndexNone
Range(FR).Interior.ColorIndex = 3
NextFlash = Now + TimeSerial(0, 0, 1)
Application.OnTime NextFlash, "StartFlashing", , True......................