One of the features that consumers may find useful is retracing their path as they navigate through different workbooks, different sheets, and different windows. This navigation would be equivalent of a web browser’s Previous and Next feature. While Excel does not support this natively, the code in this note enables this capability.
For a version in a page by itself (i.e., not in a scrollable iframe as below) visit http://www.tushar-mehta.com/publish_train/xl_vba_cases/1110%20Workbook%20Navigation%20Retrace.shtml
Hi Tushar,
I’ve created a similar tool years ago called “GoBack”, which you can download here:
http://www.jkp-ads.com/download.asp
Look for a file called goback.zip
This one does have a UI, on the add-ins tab of the ribbon.
I’ve also added this feature to the FormulaDesk add-in. The FormulaDesk menu has ‘Back’ and ‘Forward’ buttons with dropdowns to select any location in the history. Alternatively, press ALT+LEFT or ALT+RIGHT to go back or forward. http://www.formuladesk.com