Problem to print sheet names and convert names as links to those sheets

[DJ]

Hi All,


Kindly help me with the problem. I am required to print names of all the sheets in a workbook and make these names as Hyperlink to respective worksheets.


I am able to print sheet names but don't know how to convert them as hyperlink.


Thanks,

DJ

 

[Hui]

DJ


Have a look at the two links at: http://chandoo.org/wp/2011/03/31/excel-hyperlinks/

Go down to Tables of Contents (towards the bottom of the post)

 

[DJ]

Hi Hui,


Thanks a lot for the link, it helped me a lot.


DJ