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?
|