Try this Mike

Set Ash = ActiveSheet
......
Ash.Select



Sub test()
Dim Wb1 As Workbook
Dim Wb2 As Workbook
Dim Ash As Worksheet
Application.ScreenUpdating = False
Set Ash = ActiveSheet
Set Wb1 = ActiveWorkbook
Set Wb2 = Workbooks.Open("C:\data\ron.xls")
Wb2.Sheets(1).Copy After:=Wb1.Sheets(Wb1.Sheets.Count)
Wb2.Close False
Ash.Select
Application.ScreenUpdating = True
End Sub


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Mike Fogleman" wrote in message ...
I have 3 sheets in a WB. When it opens, Sheet ("Master") is active. If I
move/copy a sheet from another WB into it, the new sheet is active. Is there
a way to re-activate Sheet ("Master"), perhaps in a Workbook event, after
the new sheet is added? A one -time event, so I can activate the new sheet
later and use it without the WB going back to Sheet ("Master") each time.
Thanks, Mike