Trigger event when switching workbooks or applications

Question

Hi, I am trying to trigger and event when I either

#1 switch workbooks and reselect the original workbook or

#2 switch applications, say to IE, and then reselect the original workbook

 

I have tried all sorts of variations using workbook activate / window activate events, but the event does not trigger unless moving withing the original workbook

Any ideas gratefully accepted

Regards

James

Answer 1

This is really interesting to read about. I did some testing on various methods (using Timer and Do Events, etc.) but I couldn't get anything to work. It looks like the only method that works is using windows API. Look at https://www.excelforum.com/excel-programming-vba-macros/1043238-test-if-application-has-focus.html and see if this can help you out. I'll keep trying something but this is the only partial answer I can seem to get. I haven't been able to get it to continuously check for focus, or to trigger when the window focuses, but It is a start. Let us know if you get this to work out any more.