Excel App gets focus

S

Steven

If you have an excel file open and then switch to another applicaiton...then
select the excel file again on the taskbar ... how can you catch this and run
a macro with the change in application back to excel? I want a macro to run
each time the file is accessed. Whether going from an excel file to this
file or from a different application to this file. I have tried
Workbook_Activate ... but that only works from one excel file to another ...
it does not seem to catch the return to the excel file from a different
application.

Thank you for your help.

Steven
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top