Create index with hyperlinks to all sheets using Excel VBA

preview_player
Показать описание
This video will show one way to compose a macro, which will not only list visible worksheets, but also hidden worksheets in a hyperlinked table of contents

As per earlier videos, it can sometimes be quite challenging navigating through numerous worksheets containing different financial information.

Spreadsheet users often overlook or forget about the potential for hidden worksheets too.

This macro generated approach will help to improve this issue, and allow users to navigate to separate sheets; including hidden ones which will be individually denoted.
Рекомендации по теме
Комментарии
Автор

Is it possible to auto-create new links in the table of contents for recently added worksheets?

stephenboyd
Автор

what we will do when we are adding a sheet after the implementation of the formula??

albabtainplastic
Автор

how about only creating links to certain worksheets?

RealDC
visit shbcf.ru