How to - Show tab names in a list as hyperlinks

Hi All,


I need some help editing code to show tab names as hyperlinks.
The code was written by a forum member (Pete from Warrington, if I remember correctly) and works perfectly

At present the code (see below) creates a list of all the sales invoices that I produce each month, showing amount, client, date, etc and tab name.

The document is now becoming quite large and I would like to be able to go directly to the sheet using a hyperlink to the tab name instead of searching through all the tabs on the bottom of the screen.

So is it possible to show the tab name a s a hyperlink in the list?

Many thanks in advance,

Chris


Here is the code in full--------------------------------------------------------------------------------------------

Please Login or Register  to view this content.

----------------------------------------------------------------------------------------------------------------------

Many thanks in advance,

Chris

Hi Andy

Thanks for the quick response!
That worked perfectly.


Chris