Closing a workbook upon opening another
I have been using macros to open, close and activate workbooks for years.
However, recently some users are not able to activate a workbook after Excel
has opened a different workbook because it closed the previous workbook.
Make sense so far.
Is there something in Excel that I can switch to get the program to leave
workbooks open when opening another?
Thanks,
Dave
|