Hi,

I tweaked the standard module code as so it won't error out if you haven't left the current sheet. Seems to work ok...

Option Explicit
Sub PrevWb()
    On Error GoTo nada
    Worksheets(ThisWorkbook.PrevWb.Name).Activate
    Exit Sub
nada:
    MsgBox "You haven't left the current sheet yet."
End Sub