shortcut to go to last active sheet of a workbook

[gautam5]

Is there any short cut to go to last work sheet I was working on (in the same work book)

[6StringJazzer]

There is no built-in way to do this. It wouldn't be too hard to do with VBA. Would you want to go in that direction?

[gautam5]

yup. I will make like so comfortable

[6StringJazzer]

This would be specific to a single workbook. I don't have a solution that would work for any workbook you open.

[gautam5]

please reveal the magic.

[6StringJazzer]

Here is an example. Note that this is a VBA solution and is not suited for "New Users/Basics." You have to know the basics about how to implement VBA in your file.

Code in ThisWorkbook detects whenever the sheet changes, and saves the sheet that was just exited.

Module LastSheet has a Sub that returns to the sheet that was saved above.

Each sheet has a button that calls the Sub above.

It may not be desirable to have a button in each sheet. You can use a single button on the quick access toolbar.

If I think of a way to do this for all workbooks I'll let you know.