'Define a local variable
Dim lastSheet As Worksheet
Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
'Stored info for later use
Set lastSheet = Sh
End Sub
Sub GoBack()
'This is the macro to take us back to previous sheet
lastSheet.Activate
End Sub
Sub GoBack()
'This is the macro to take us back to previous sheet
If lastSheet Is Nothing Then Exit Sub 'Might want to add a msgBox...your call
lastSheet.Activate
End Sub