On Apr 4, 4:05*pm, Looping through
wrote:
I have a reminder set to pop up based automatically when a certain criteria
is meet. I know how to do this, but if user has minimized covered up the
current workbook, how do I make the program flash or become the active
projram on there screen to notify them to do something.

Any Ideas?

Add this to your code to Maximize the screen. Change the workbook name
accordingly.

Windows("Book1").WindowState = xlMaximized