Cell change events

R

Richard

MS OS: XP
Excel 2000

I keep my Excel program minimized. When a cell or range of cells changes in
sheet2 I want the Excel program to maximized and make a sound.

How can this be done?

Please Help

Thanks in Advance.
 
C

CLR

Maybe this in your Sheet Module.........

Private Sub Worksheet_Calculate()
Call ChangeNotification
End Sub

And this in a regular module...........

Sub ChangeNotification()
ActiveWindow.WindowState = xlMaximized
Call sndPlaySound32("c:\harleyre.WAV", 0)
End Sub

Vaya con Dios,
Chuck, CABGx3
 
Top