Dear all,
I have more than 500 worksheets under the same workbook. The worksheets themselves don’t relate on each other (there is no internal links, which sucks). Is there any way I can create a shortcut linking to each worksheet directly like the Thumbnail bar on Acrobat Reader?
For example, can we arrange the worksheets in Alphabet order under something like the thumbnail? I notice if I right click any worksheet tag and choose view code, a VBA project window will pump out listing all worksheets in order (but that's only for VBA Coding). But it's exactly similar to what I want to be shown on each worksheet. In such case I don’t really have to take as long as 2 minutes by only finding the worksheet I need?
Thanks for all the help!
Bookmarks