i want to set an alarm in my sheet... if A1=75%,"sound should go off", else be silent.....
F Fuzzy Feb 12, 2009 #1 i want to set an alarm in my sheet... if A1=75%,"sound should go off", else be silent.....
S Shane Devenshire Feb 12, 2009 #2 Hi, Insert a sound object from the Clip Art gallary. Then record a macro when you double-click it. Add an Worksheet_Change macro to trigger when A1 meets your condition and runs the recorded macro.
Hi, Insert a sound object from the Clip Art gallary. Then record a macro when you double-click it. Add an Worksheet_Change macro to trigger when A1 meets your condition and runs the recorded macro.
