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.

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.

How To Create A Dynamic Worksheet Selection Popup Menu - 87