Gruß
Option Explicit
Public OldSheet As String
Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
OldSheet = Sh.Name
End Sub
Sub VorherSheet()
On Error Resume Next
Sheets(OldSheet).Activate
End Sub
Das Sub "VorherSheet" kannst du jetzt aufrufen wie du möchtest (Shortcut, Button ....)
if activesheet.index>1 then activesheet.previous.activate
If Not ActiveSheet.Previous Is Nothing Then ActiveSheet.Previous.Activate