View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default 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