Run code once

Put it in the Thisworkbook code module

Private Sub Worksheet_Open()
Dim c As Range
    For Each c In Worksheets("whatever it is called").Range("O4:O46")
        If c.Value <= 0 Then MsgBox "Updates are available", vbInformation
    Next c
End Sub