Hello,
I asked this question in 2012 and didn't get a solution so I'm hoping that somebody will be able to help me 4 years later.
I would like to have a "PREVIOUS" navigation button in a workbook that goes back to the previously activated worksheet, which may or may not be physically the previous worksheet in the workbook. In other words, if I go from Sheet #1, to Sheet #3, to Sheet #5, I'd like to return to Sheet #3 from Sheet #5 (rather then navigating back to Sheet #4). I think what I need is a macro to hold the sheet names in the order they were activated so that the user can continue to work his way backward, in reverse order of activation, to the very beginning (sheet 1) if desired.
I am inexpert with VB and appreciate any handholding (and detailed advice).
Michele
I asked this question in 2012 and didn't get a solution so I'm hoping that somebody will be able to help me 4 years later.
I would like to have a "PREVIOUS" navigation button in a workbook that goes back to the previously activated worksheet, which may or may not be physically the previous worksheet in the workbook. In other words, if I go from Sheet #1, to Sheet #3, to Sheet #5, I'd like to return to Sheet #3 from Sheet #5 (rather then navigating back to Sheet #4). I think what I need is a macro to hold the sheet names in the order they were activated so that the user can continue to work his way backward, in reverse order of activation, to the very beginning (sheet 1) if desired.
I am inexpert with VB and appreciate any handholding (and detailed advice).
Michele