VBA Back Button to go back through history of previously active worksheets.

I'm trying to use VBA to create a "Back" button that allows me to go back through, in order, a series or previously active worksheets.

I have a an Excel (2016) workbook with over 200 worksheets and I use a "Navigation Bar" (i.e. Group of simple "Goto" macros) at the top of each worksheet to navigate between 6 different "Modules" within the same workbook. The "Primary" Navigation Bar allows me to navigate to "Secondary" sub-menus within in each of the "modules" using other "Goto" macros. From there I can drill down to more levels, ultimately drilling down up to 5 levels.
The code below works if I continue to "drill-down" within the same module. It allows me to return all the way back to Level 1 (i.e. The MainPage), however, something goes wrong when I try to:

• - Move "up and down" within the same module (i.e. If I'm at a 3rd Level of menus and select an option to take me to the 4th level and use the "Back" Button to bring me back to the 3rd Level and then select a different path to get to the 4th level, when I use the "Back" button again, instead of bringing me back to the 3rd Level, it brings me back to the 2nd Level.

Any advice or guidance you can provide would be greatly appreciated. Thank you in advance!

In VBA Module

Please Login or Register  to view this content.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

I did it for you this time. Please read forum rules. Thanks