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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks