View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default 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