how to create buttons which point to other worksheets?

[AzMan]

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.

 

[flow23]

make the buttons in a sheet. then select each button in design mode. and
insert hyperlink

 

[Toppers]

Assign macro to each button (using FORMS toolbar):


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

HTH

 

[MageeStringer]

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.

There are some great codes here for sheet table of contents

http://www.mvps.org/dmcritchie/excel/buildtoc.htm

 

[John James]

You can avoid buttons and macros altogether by inserting hyperlinks
Ctrl + K

 

[Dave Peterson]

How about an addin?

From Debra Dalgleish's site:
http://www.contextures.com/xlToolbar01.html