Detect attempt to switch between open excel files (windows) during loop

Great forum for finding answers. Thanks for all the help in the past.

Is it possible to detect when the user attempts to switch between open excel windows during the looping of this code? If the user minimizes the activewindow and selects another window the execution stops as desired. If the user attempts to switch between instances on the taskbar the code does not stop.

Please Login or Register  to view this content.

xladept,

The Workbook_deactivate event is raised by minimizing the workbook but the Workbook_worksheetDeactivate and Worksheet_Deactivate events never fire. None of the three occur when clicking on the open filename in the taskbar.

Thanks

No. While the sub is looping other workbooks in the single instance of Excel cannot be activated without minimizing the activeworkbook (an action that I can't expect the user will perform reliably).

Yes. I want the user to be able to suspend the zoom resizing of the frozen panes and select other open workbooks if needed.

When two workbooks are open (book1 and zoombook for example) as windows within Excel I understand this to be one instance of Excel. If the macro is run in zoombook it prevents switching to book1 unless zoombook is minimized. I had looked at comparing the application.hwnd but don't have enough knowledge about the API function to make it work. The hwnd that I was trapping was of the zoombook window. I will look into that.