View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ken
 
Posts: n/a
Default hyperlink to another worksheet

You can create a link directly in a cell.

Right click the cell where you want the link.
Select Hyperlink.
Select "Place In This Document" on the left.
Select the sheet you want to link to.
Then specify the cell you want to link to (Optional).
Click OK.
The link will appear blue. Just click it.

"billy boy" wrote:

How do I add a button to a worksheet that when I click it, it will bring me
to a differnt worksheet? For example, I'm working on sheet 1 on line 150, I
would like to click a button to bring me to sheet 2 on line 150. Is this
possible?