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

lgrande

Board Regular
Joined
Nov 2, 2012
Messages
60
Office Version
  1. 365
Platform
  1. Windows
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.
 
Last edited by a moderator:

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
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:

1738144434508.png


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

1738144569748.png


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

1738144615539.png


This is where I've copied everything:

1738144392895.png

Any help would be hugely appreciated!
Thanks
 

Attachments

  • 1738144553610.png
    1738144553610.png
    39.2 KB · Views: 1
  • 1738144569723.png
    1738144569723.png
    39.2 KB · Views: 1
Upvote 0
Hello,
If you don't know how/want to add references to the “Microsoft Scripting Runtime”, just change
VBA Code:
Dim PreviousSheets As scripting.Dictionary
to
VBA Code:
Dim PreviousSheets As Object
 
Upvote 0

Forum statistics

Threads
1,226,693
Messages
6,192,463
Members
453,725
Latest member
cvsdatreas

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top