Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

In this question, he was asking about keyboard shortcut to switch tabs. But this shortcut moves the sheet backward or forward, which means that pressing Ctrl+PageUp on the last sheet doesn't move the first sheet.

Is there any shortcut which allows circular switching (like Ctrl-Tab in Windows)?

share|improve this question
1  
You could write your own macro to do this and assign it to something like Ctrl+Shift+PageUp (or any other key combination that works for you) –  jonsca Aug 18 '11 at 12:45

1 Answer 1

up vote 4 down vote accepted

This is a simple version of what I described in the comment.

Sub SwitchSheets()
    Dim NextSheet As Worksheet
    Set NextSheet = ActiveSheet.Next
    If NextSheet Is Nothing Then
        ThisWorkbook.Sheets(1).Activate
    Else
        NextSheet.Select
    End If
End Sub

From the View tab click on Macros, select SwitchSheets, go to Options and set a shortcut key for it (holding down Shift as needed, to add that into the chord).

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.