How To Create Push Buttons to Link To Other Sheets

**modytrane** · 02-13-2008, 05:29 PM

I have a workbook with several sheets.
On the main sheet, I would like to create a list of buttons and link them to other sheets.
This way user can click on a button and go to appropriate worksheets.
Thanks for any help.
modytrane

**starguy** · 02-14-2008, 05:34 AM

You can create hyperlinks to other sheets.
Follow link below and see detail of "Create a hyperlink to a specific location in a workbook".

http://office.microsoft.com/en-us/ex...995161033.aspx

**Dan27** · 02-14-2008, 06:44 AM

Hello

The easiest way to do this is to draw the button using AutoShapes. There is one shaped like a button. Once you've drawn it you can right click on it and select hyperlink. You then select link to place in this document.