very difficult code that will close original workbook and leave another open
From the quick summary:
Instead of closing the first workbook, you could hide it by setting the IsAddIn property of the Workbook to True, run the rest of your code, and then close it at the very end.
|