How To Create A Custom Navigation System In Excel - Part 1/6

What is an Excel custom navigation system? Switching between sheets, unless using keyboard shortcuts, means moving the mouse pointer all the way to the bottom of the screen. With multiple sheets and workbooks, this can be onerous - is there a better way?

Download the file here:
tinyurl.com/y5e2udtb

Video 1 - Introduction
   • How To Create A Custom Navigation System I...…

Video 2 - Create a shape and duplicate it using VBA
   • How To Create A Custom Navigation System I...  

Video 3 - Use VBA to position shapes
   • How To Create A Custom Navigation System I...  

Video 4 - Use VBA to control text that appears in shapes
   • How To Create A Custom Navigation System I...  

Video 5 - Use VBA to navigate to a sheet dynamically
   • How To Create A Custom Navigation System I...  

Video 6 - Use VBA to copy / paste shapes across sheets
   • How To Create A Custom Navigation System I...  

The Excel custom navigation system is a neat alternative. It positions navigation buttons at the top of the worksheet, not at the bottom, facilitating smooth navigation. It also creates a distinctive visual effect, similar to a 'cockpit' or car dashboard, which gives the spreadsheet a professional look.

But, from the learning perspective, there is something more important. Building a custom navigation systems presents an opportunity to learn new coding techniques. Clearly, we do no want to have to create and position all the buttons manually! So, what coding techniques will allow us to do it quickly, precisely and minimise stress?

The Excel custom navigation system video series takes you through the main steps. We explore how to create multiple buttons, how to position them, how to trigger the right code, and how to copy them across sheets. Some of the code is quite intricate - you can see Chris get into a coding tangle, and work his way out!

Why not try creating your own Excel custom navigation system? Let us know how you get on!

For regular spreadsheet hints and tips and more on the #ExcelRevolution:
www.facebook.com/TigerSpreadsheetSolutions
twitter.com/TigSpreadsheets
tigerspreadsheetsolutions.co.uk/