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
|