Cell change events

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Richard - 16 May 2007 15:38 GMT

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.

Signature

Richard

Reply to this Message

Richard - 16 May 2007 15:52 GMT

This change is the result of a caculation.

Signature

Richard

> MS OS: XP
> Excel 2000
[quoted text clipped - 7 lines]
>
> Thanks in Advance.

Reply to this Message

CLR - 16 May 2007 16:18 GMT

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

> This change is the result of a caculation.
>
[quoted text clipped - 9 lines]
> >
> > Thanks in Advance.

Reply to this Message