I am not quite sure how to ask this question b/c I am not sure of the correct terminology but here it goes. I have 2 workbooks each with their own closing procedures. Let's assume one workbook is open and I open the 2nd workbook from a macro in the 1st. How do I make the second book assume the activewindow position? Let me give an example of what I mean to better explain. If I have both workbooks open and I hit the red x in the upper right corner, it runs the before close procedures for the first workbook. So far I have created variables to bypass the before close sub from wb 1 but it is getting complicated. It occurred to me that perhaps there is some simple solution that makes the 2nd workbook the activewindow allowing its before close sub to run instead of wb 1's.
Help please.
Help please.