View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Merlynsdad Merlynsdad is offline
external usenet poster
 
Posts: 37
Default Calling open workbook from another workbook

I'm switching back and forth between two workbooks. I open Book1 from the
ThisWorkbook_Open event in Book2, then switch back to Book2 with a
Me.Activate since I'm still in it. How do I switch back to the already opened
Book1? Presumably this is also how I would switch back to Book2 while in
Book1?