View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Epinn Epinn is offline
external usenet poster
 
Posts: 605
Default Button- Hyperlink- please help?

If I understand your question correctly ......

Draw the AutoShape by using the drawing toolbar. Then right-click on the shape, hyperlink, place in this document and choose your sheet.

A fancy way is to create a drop-down list with all the sheet names. Then use hyperlink( ) to link to the selected worksheet. Don't even need a combobox.

Hope this helps.

Epinn

"Anand vijay" wrote in message ...
How do i create hyperlink for buttons so that whrn i click on button i go to
another sheet in same workbook at a perticular point?