Is there a keyboard shortcut to circularly switch sheets in Excel?

Question

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)?

Answer 1

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).