Return to the sheet you just came from?

[itsme2]

What do incorporate into this code (if possible) that once the sheet viewed has been closed will return me to the sheet that sent me there...

Does that make sense?

Private Sub CloseSheet()
    ActiveWindow.SelectedSheets.Visible = False
End Sub

 

[Zack Barresse]

Hi there,

Maybe something like this in your ThisWorkbook module would give you the last sheet viewed...

Public LastSheet As String

Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
    LastSheet = Sh.Name
End Sub

Then you could use ..

Sheets(LastSheet).Select