link cell to open a worksheet

[wilbo]

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

 

[Tom Hutchins]

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