View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tom Hutchins Tom Hutchins is offline
external usenet poster
 
Posts: 1,069
Default link cell to open a worksheet

Select the cell in worksheet1 where you want this to work. Insert a hyperlink
to the other worksheet. In Excel 2003, it's Insert Hyperlink. In Excel
2007, it's Insert | Links | Hyperlink. Browse to the desired
worksheet/workbook/etc. then click OK.

Hope this helps,

Hutch

"wilbo" wrote:

I want to open up worksheet2 when I click on a cell in worksheet1, how can I
do this?