C chuck Jul 13, 2009 #1 I would like to have a sound generated when a sum in a specific cell is been surpassed
L Luke M Jul 13, 2009 #2 Right click on sheet tab, view code, paste this in. Private Sub Worksheet_Calculate() If Range("A2").Value > 5 Then Beep End Sub Modify as needed.
Right click on sheet tab, view code, paste this in. Private Sub Worksheet_Calculate() If Range("A2").Value > 5 Then Beep End Sub Modify as needed.
