Get The Completed Workbook

If you have a workbook with a lot of sheets, then navigating through them can be a pain. This tip is dead simple to implement and will allow the someone to easily navigate to a sheet by using a popup menu. All you need to do is add this small bit of VBA code to your workbook then you can run it by adding and assigning your code to a button.

 

Sub SheetMenu()
    Application.CommandBars("Workbook tabs").ShowPopup
End Sub

 

Read this post about How To Use The VBA Code You Find Online to find out how to use this VBA code. When you have this code in your worksheet, you might also want an easy and obvious way for someone to use it like adding a button to run it. You can find out how to do that in this post about How To Add A Form Control Button To Run Your VBA Code.

 

Step-001-How-To-Create-A-Dynamic-Worksheet-Selection-Popup-Menu How To Create A Dynamic Worksheet Selection Popup Menu

 

Now when you press your button, a popup with all the workbook’s sheets listed will display and you will be able to select one of the sheets to navigate to. It’s a small touch that can really enhance usability for workbooks with a lot of sheets.