Software

Ask something
Discussion Locked

Automatic alarms in Excel 2000

0 helpful
3 replies

by pottenhausen

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Does anyone know if there is a way to have an Excel spreadsheet display an alarm when the workbook is opened if certain criteria is entered in the spreadsheet?

3 replies

by dklippert

Select the range that will contain the value.
Go to Format>Conditional Formatting.
This will change the appearence of the cell to call attention to it.

You could also write an Auto_Open macro that would pop up a MSG box.

Sub Auto_Open()
If (Range("A1").Value = 6) Then
MsgBox ("Run for the hills! It's 6!")
End If
End Sub

This discussion is closed to new replies.