Michael,

In the target workbook, add this code to the ThisWorkbook code module

Private Sub Workbook_Open()
Thisworkbook.Worksheets("Sheet3").Activate
End Sub

change the Sheet3 to your name

--

HTH

RP
(remove nothere from the email address if mailing direct)


"OscarC" wrote in message
...
Hello,

Just a quick one. Does anyone know what the VB code is to make Excel
open a workbook with a specific worksheet selected?


thanks,

Michael