Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlinks to many Sheets within a Workbook
Hi! Experts I have Workbook which have 98 Sheets include a "UNIQUE LIST" Which have Names of the Sheets. Now i want to insert Hyperlinks in the "UNIQUE LIST" to other Sheets. Ex: If i Click on CZ001 it take me to CZ001 Sheet. If i click on WZ009 it take me to WZ009 and so on. I knew how to insert the Hyperlinks but i want any Formula or Code that will do me with in a Mintues. MY Second Question is: Say i Click on CZ001 it take me to CZ001 and When i click on A1 of Sheet!CZ001 it take me to "UNIQUE LIST" If i Click on WZ009 in "UNIQUE LIST" it take to me Sheet!WZ009, when i Click on A1 of Sheet!WZ009 it take me to "UNIQUE LIST" Is this Possible Thanks in Advance Hardeep Kanwar -- hardeep.kanwar ------------------------------------------------------------------------ hardeep.kanwar's Profile: http://www.thecodecage.com/forumz/member.php?userid=170 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=107000 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Want to update hyperlinks through multiple sheets but can't | Excel Worksheet Functions | |||
Hyperlinks to hidden sheets | Excel Discussion (Misc queries) | |||
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Worksheet Functions | |||
Hyperlinks With Workbook With Hidden Sheets | Excel Discussion (Misc queries) |