LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Want to update hyperlinks through multiple sheets but can't Billznik Excel Worksheet Functions 1 February 28th 12 06:19 AM
Hyperlinks to hidden sheets Aggie G Excel Discussion (Misc queries) 3 June 18th 07 04:43 PM
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA Amaxwell Excel Worksheet Functions 4 August 17th 06 06:23 AM
How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? Dmitry Excel Worksheet Functions 6 March 29th 06 12:43 PM
Hyperlinks With Workbook With Hidden Sheets MPB Excel Discussion (Misc queries) 0 April 27th 05 05:30 PM


All times are GMT +1. The time now is 08:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"