From the Tools menu, select Macro | Visual Basic Editor
From the Project window, doubleclick ThisWorkbook

Assuming Sheet2 is the worksheet you want activated when the workbook opens.

Copy this code in:

Private Sub Workbook_Open()
Worksheets("Sheet2").Activate
End Sub

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"ThaiNB" wrote in message
...
When I open a workbook, it always shows a specific worksheet which I don't
want to work with. I have to click on the worksheet I want everytime I
open
this workbook. How can I open it and have it shows the worksheet I want by
default?

Thanx in advance.