[Solved] Last Active Sheet In Vba | Vb - Code Explorer

[Solved] Last Active Sheet In Vba | Vb - Code Explorer | yomemimo.com

Question : Last Active Sheet in vba

Answered by : comfortable-copperhead-ggy1lgse680e

Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
    Set LstSht = Sh
End Sub

Source : https://www.extendoffice.com/documents/excel/2910-excel-return-to-last-active-sheet.html | Last Update : Tue, 06 Jul 21

Question : Last Active Sheet in vba conti

Answered by : comfortable-copperhead-ggy1lgse680e

Public LstSht As Worksheet
Sub GoToLast()
    LstSht.Activate
End Sub

Source : https://www.extendoffice.com/documents/excel/2910-excel-return-to-last-active-sheet.html | Last Update : Tue, 06 Jul 21

yomemimo.com