Windows("Book2").Activate
or
Windows("Book2.xls").Activate

depending on what is in the Window Title Bar.
--
Gary''s Student - gsnu200908


"Merlynsdad" wrote:

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?