Perry,
Have you tried the App_WindowActivate or WorkbookActivate events ?

NickHK

"Perry" wrote in message
ups.com...
I want to be able to run a macro in a spreadsheet (which is open but
out of focus) when the user re-select Excel as the active application.

I've tried Excel Application Events
Public WithEvents App As Application etc
but this only works when first opening Excel or a Workbook or oggling
between sheets.

As I say, I want to have an excel book open and every time the user
moves into Excel (with the sheet already in "view") from say Outlook or
any other application - Excel receing control - the Macro would run.

Can anyone help?

Thanks