message box based on cell value of any tab selected

[Watchdawg]

OK, I've looked around and seen some ideas on what I'm looking for, but nothing has panned out.
I have a workbook with quite a few tabs on it. In cell C64 is a number from 0.0 to 10 on each page. When selecting any tab, if that particular cell is 0.0 value, then I want a message box to pop up and the focus to be set to that cell.
I've done this in a worksheet_change sub, but I'm failing miserably for some reason.

Does anyone have any ideas? I was trying to do something as simple as :

Private Sub Worksheet_Change()
If Range("C64").Value = 0.0 Then
    MsgBox "This employee has no points"
End if
End Sub

 

[Joe4]

The "Worksheet_Change" event only fires when a cell on a sheet is physically changed.
If you want this to run when a sheet is activated, put this code in the "ThisWorkbook" module of your workbook:

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
If Range("C64").Value = 0 Then
    MsgBox "This employee has no points"
End If
End Sub

 

[Watchdawg]

The "Worksheet_Change" event only fires when a cell on a sheet is physically changed.
If you want this to run when a sheet is activated, put this code in the "ThisWorkbook" module of your workbook:

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
If Range("C64").Value = 0 Then
    MsgBox "This employee has no points"
End If
End Sub

Perfect! Thank you so much!

 

[Joe4]

You are welcome!