I have a scheduled macro that downloads data every 10 minutes. A problem
arises though when the user has another workbook active when the macro is
running. The macro tries to run in the active workbook.
I could make the macro activate the correct workbook before doing the
download, but that interrupts the user's work in another workbook. Is there a
way to keep the scheduled macro in the background, and in the correct
workbook, leaving the user undisturbed working in a different active workbook?

Andy