Excel shortcut: switching back and forth between that last active sheet and the current exit sheet

Posted by thomasssssss on Super User See other posts from Super User or by thomasssssss
Published on 2010-03-21T11:02:17Z Indexed on 2010/03/21 11:11 UTC
Read the original article Hit count: 294

Filed under:
|
|

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?

© Super User or respective owner

Related posts about shortcut

Related posts about excel