Private Sub CommandButton1_Click()
Sheets("Sheet2").Activate
End Sub

If this post helps click Yes
---------------
Jacob Skaria


"NIDAL" wrote:

I have workbook contain about 45 sheets, and I need to create one Summary
sheat containing buttons for names of all sheats.
The qustion is How to make a each Button open a specified sheet.
best regards