I would like to copy a worksheet to a new workbook using
direct syntax...unfortunately the activeworkbook does not
change to the new workbook when I do so...I would prefer
not to use the Worksheets("Sheet1") approach and instead
use wks (such as set wks = wkb.worksheets(1))

Here is my

Set wkb = thisworkbook
set wks = wkb.worksheets(1)
wks.copy

msgbox ActiveWorkbook.name

How can I make the ActiveWorkbook name change to the
newly created workbook

Thanks

Matt