Sound+color alert if cell changed in another worksheet
 

Hi!
I have 2 worksheets. In the first one I enter data regularely and in
the second one never because it gets data from the first one (but
rarely is changed something here since it keeps track of maximum and
minimum values from first worksheet). I want a way to know at the time
I enter data in worksheet 1 if something has changed in worksheet 2
(the way I would prefer the alert here would be a beep or an autoplay
of a little .wav file) then when I go to worksheet 2 I want to easily
locate the newly changed values by having their cells background in red
for a certain amount of time (lets say 24 hours - so only if their
values changed today, or in red until the workbook is closed). The
cells in worksheet 2 I'm talking about are D3:D23. How do I do that ?

Thanks.


--
florinel
------------------------------------------------------------------------
florinel's Profile: http://www.excelforum.com/member.php...o&userid=33827
View this thread: http://www.excelforum.com/showthread...hreadid=545548