List All Your Sheets Efficiently in Excel (10 Levels)

*Watch more videos*

*Click here for the article with full VBA code:*

*Download the sample workbook with code:*

*Chapters:*
00:00 Introduction
00:57 Level 1: Manual Tricks for Listing Sheets
01:39 Level 2: Use Formulas for Sheet Listing
05:50 Level 3: Automate with VBA
10:51 Level 4: Enhance VBA with New Features
13:54 Level 5: Error Checking and Improvements
16:11 Level 6: Optimize Sheet List Display
18:04 Level 7: Add Padding for Readability
22:07 Level 8: Create Clickable Sheet Names
24:26 Level 9: Add Back Buttons for Easy Navigation
27:03 Level 10: Automate Sheet List Refresh
29:32 Conclusion and Resources

[launchexcel]

*❤ CHAPTERS:*
00:00 - Introduction
00:57 - Level 1: Manual Tricks for Listing Sheets
01:39 - Level 2: Use Formulas for Sheet Listing
05:50 - Level 3: Automate with VBA
10:51 - Level 4: Enhance VBA with New Features
13:54 - Level 5: Error Checking and Improvements
16:11 - Level 6: Optimize Sheet List Display
18:04 - Level 7: Add Padding for Readability
22:07 - Level 8: Create Clickable Sheet Names
24:26 - Level 9: Add Back Buttons for Easy Navigation
27:03 - Level 10: Automate Sheet List Refresh
29:32 - Conclusion and Resources

[learningtogetheredu]

I am learning here thanks for the video. Learning is a virtue. Let's keep learning

[ExcelOffTheGrid]

Welcome back Victor - it's nice to see some new videos from you.

[markhuang]

Thank you Victor for the excellent video.

[hichamhadj]

Excellent video, especially the boss level part

[myszek__]

Super video Victor. Glad I stumbled onto your channel. I really like your delivery. Now here is the challenge: How do I do the same things in LibreOffice/Calc? Though probably not the vba part.

[robbe]

Nice video.
Please keep us informed when the download file is available.
Thank you.

[azlanm]

Hai Victor, , .. excellent video...
if you could just advise on how to insert macro command on how to position the Navigation button
thank you

[RobertPinnock-tvjw]

Enjoyed the video on my TV. But really need to read the VBA macro - can you please give me link so that I can follow the video again with a hard copy of the macro in front of me.. Many thanks

[drog]

This was a great video, however, that VBA is very complicated. I do know excel very well, just not the VBA stuff. I was wondering if there is a way to do the hyperlink back and forth if you just did the transpose part to get the sheet names? I have 193 or so sheets in one of my excel sheets and would like to go back and forth but without all the VBA coding, except for the VBA for hyperlinking. Thank you

[zs]

Hi Victor, It's ZS again :) This solution is perfect. I will certainly give it a go but I need a small help. When listing the Sheets, could these be sorted A-Z? My sheet names are Alpha numeric and sorted list would be great. I have no experience of VBA and hoping to embark on the learning journey and makinng my work a bit easier.

[fevziciddi]

It would be nice if the pages were sorted from A to Z or Smallest to Largest

[TheAhmedrty]

saved the workbook as new workbook but now I just get #BLOCKED! as a result instead of the sheet name.

[whimpypatrol]

No offense, but from the get-go, i don't like the idea of VBA. In the last 7 or 8 years, i dont remember having to use it even once given the level of abstract programming that can be done with the tools and data structures accessible on an excel spreadsheet. Even writing a bona-fide stochastic simulation or programming a statistical analysis package.

[eduardopimentel]

Great video, Victor. Thanks a lot!!
In my situation, the GET.WORKBOOK function is resulting in the "#NAME?" error. I'm using Excel 365, do you have any idea what could be going on?