Excel: Hyperlink

I am having workbook containing number of worksheets say around 200. in summary sheet ( sheet no. 1 ) , I have list of name of all worksheet having hyperlink to particular sheet. now i want to change hypelink all together . any formula or any VBA code available ?

This question generated 20 answers. To proceed to the answers, click here.

This thread is current as of October 31, 2014.

For more resources for Microsoft Excel