Shortcut to toggle back to the last worksheet you were working in. Is there such a thing?

[lgrande]

Hi,
I was wondering if you can toggle back to the last worksheet you were working in. I have many worksheets and it takes too much time to find the last worksheet I was in. Any help would be appreciated, I do not want to have to create a VBA or Macro. I'm still learning how to do them. Thanks so much.

Linda G.

 

[lgrande]

Thanks so much Jeff, I will try these.

 

[jamesam]

Here is a VBA solution that is installed into the PERSONAL workbook and will allow going "back" to any sheet in any workbook.

Hi Jeff,

I think I've added these as you described but I'm getting this error when I open Excel:

Then if I try to run StartSheetTracker then I get this error:

And if I try to run GoToLastSheet I get this error:

This is where I've copied everything:

Any help would be hugely appreciated!
Thanks

 

[saboh12617]

Hello,
If you don't know how/want to add references to the “Microsoft Scripting Runtime”, just change

Dim PreviousSheets As scripting.Dictionary

to

Dim PreviousSheets As Object