I used xl97 and winnt 4.0 at work and I don't recall having to do this. I use
xl2k and win2k and that excel icon flashes in the taskbar when there's a
dialog/msgbox to dismiss.
But maybe something like this will force it:
AppActivate Application.Caption
(but the simple msgbox in a minimized window made the icon flash in win98.)
"AndyKB <" wrote:
I was using the Application.OnTime event to write a simple macro in
Excel XP that would display a message box 10 seconds from when the
macro was run.
After starting the macro, I would minimize the Excel window, and wanted
the icon on the taskbar to flash when the message box came up. I was
wondering: how do you make the minimized Excel workbook icon flash?
(I remember that, although I don't have my old workbook, I created a
macro similar to the one above in Excel 97 on a Windows NT 4.0 machine
and I didn't have to write any extra code to get it to flash.)
Thanks in advance,
AB
---
Message posted from http://www.ExcelForum.com/
--
Dave Peterson