Excel shortcut: switching back and forth between that last active sheet and the current exit sheet
- by thomasssssss
I know the shortcut CRTL + page up/down
but I need the similar function that exists eg in internet explorer: Shift + alt
I found a macro that is close but does not entirely solve the problem:
If ActiveSheet.Name = "To Do" Then
Sheets("Budget").Activate
ElseIf ActiveSheet.Name = "Budget" Then
Sheets("To Do").Activate
I can name the A1 cell with the sheet name and use search (f5) and type the name, but this is to cumbersome.
Any ideas, guys?