Assign macro to each button (using FORMS toolbar):


Sub Button1_Click()
Worksheets("Sheet1").Activate
End Sub

HTH

"AzMan" wrote:

I have an Excel workbook. I want to have one worksheet with a list of
buttons, so that if i click one it will take me to a specific worksheet.