Hello Zachary,

Here are the API calls you will need to Flash the Application Title.
The macro Flash is a VBA routine. It should serve as model for you in
creating a suitable function for your needs.


Code:
--------------------

Public Declare Function GetActiveWindow _
Lib "User32.dll" () As Long

Public Declare Function Sleep _
Lib "Kernel32.dll" _
(ByVal dwMillisecs As Long) As Long

Declare Function FlashWindow _
Lib "User32.dll" _
(ByVal hWnd As Long, _
ByVal fInvert As Boolean) As Boolean

'The return value is the state of the window
'(active or inactive) prior to the call

Public Sub Flash()

Dim I As Integer
Dim Status As Long

For I = 1 To 7
Status = FlashWindow(GetActiveWindow(), Not Status)
Sleep (250)
Next I

End Sub

--------------------

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=482351