LinkBack URL
About LinkBacks
Good afternoon grlndxy
Does this help - it doesn't act when you click on a tab, but when you change worksheet :
HTH
Private Sub Workbook_SheetActivate(ByVal Sh As Object) If ActiveSheet.Name = "Sheet1" Then MsgBox "Sheet1 Activated" End Sub
DominicB
Good afternoon grlndxy
Does this help - it doesn't act when you click on a tab, but when you change worksheet :
HTHPrivate Sub Workbook_SheetActivate(ByVal Sh As Object) If ActiveSheet.Name = "Sheet1" Then MsgBox "Sheet1 Activated" End Sub
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
Thank you! That helps!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks