Cell change events
 

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.

--
Richard

Cell change events
 

This change is the result of a caculation.
--
Richard


"Richard" wrote:

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.

--
Richard

Cell change events
 

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



"Richard" wrote:

This change is the result of a caculation.
--
Richard


"Richard" wrote:

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.

--
Richard