| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I organize events | Excel Discussion (Misc queries) | |||
| Enabling Events | Excel Discussion (Misc queries) | |||
| Worksheet Events | Excel Discussion (Misc queries) | |||
| events? | Excel Discussion (Misc queries) | |||
| Counting the events | Excel Worksheet Functions | |||
Linear Mode
