Hi friends,
When you got lots of sheets in excel workbook, it is hard to navigate through them. Probably most of you know that it is handy to right-click on navigation bar at the bottom left corner in excel window and the menu with the list of sheets will show up (see atttached image1).
When you have lots of sheets, there is the last line "More sheets.." which shows up the "Activate" window (see atttached image2), where we can select any worksheet in activeworkbook to navigate. My problem is that I can not find any the command in VBA which will make this window ("Activate") to show up. I know that it would be easily built through VBA and Userforms, but my issue is to show up this window somehow (as it must be built-in) with or without VBA without using the mouse in this operation.
I have also attached my try to do the similar thing, however I still want to make the built-in window to apprear.
Thank you in advance for help![]()
Bookmarks