I have been scouring the web and have found VBA codes that will create a hyperlinked index of all the worksheets in the my document. But I am running into a problem. I have two particular worksheets that update automatically from an external data source and I don't want to have any hyperlink back to the index workbook on either of those two pages (screwing up my pivot tables that run off this external data). I am hoping someone could help be come up with VBA that will work under these conditions. I am also hoping it can index hidden tabs as well.
Two ideas of solutions:
#1 - Index workbook hyperlinks out, without any hyperlinks back to the index page on each separate workbook
#2 - Index workbook hyperlinks out and I can specify which workbooks to not have a hyperlink back to the index on
Any help would be great. I am using excel 2007.
Two ideas of solutions:
#1 - Index workbook hyperlinks out, without any hyperlinks back to the index page on each separate workbook
#2 - Index workbook hyperlinks out and I can specify which workbooks to not have a hyperlink back to the index on
Any help would be great. I am using excel 2007.
