Auto Execute On Focus
Posted by Michele on May 29, 2001 1:38 AM
It is possible to automatically execute VB code upon opening an Excel file. Is it possible to do the same every time the opened file gets the focus and if so, how? I have an Excel file which opens a Word document. When the user closes the Word document the Excel file is visible again but I can't get it to automatically execute some houskeeping code which is needed to get things back in order.