I am using Excel 97 VBA and need to determine in a module whether or not Excel is the current window that has the focus.
I have various timers running in the background and need to be able to perform some module sections but not others depending on whether Excel is the window that has the current focus or not.
I need something that equates to
if application.active="Microsft Excel" then
Any Ideas ?