theredfoxisquick
New Member
- Joined
- Nov 15, 2013
- Messages
- 16
I want to be able to return to the worksheet I was looking at when I activate coding that takes me away from the currently viewed worksheet. I tried this, but it is now working. Anyone know how to fix this?
Code:
[FONT=verdana] [COLOR=#006400]'in ThisWorkbook
[/COLOR][COLOR=blue]Private[/COLOR] [COLOR=blue]Sub[/COLOR] Workbook_SheetDeactivate([COLOR=blue]ByVal[/COLOR] Sh [COLOR=blue]As[/COLOR] [COLOR=blue]Object[/COLOR])
[COLOR=blue]Set[/COLOR] LstSht = Sh [COLOR=blue]End Sub[/COLOR]
[COLOR=#006400]'in Standard Module
[/COLOR][COLOR=blue]Public[/COLOR] LstSht [COLOR=blue]As[/COLOR] Worksheet
[COLOR=blue]
Sub[/COLOR] GoToLast() LstSht.Activate
[COLOR=blue]
End Sub[/COLOR] [/FONT]