i did it doesn't work
Private Sub Worksheet_Change(ByVal Target As Range)
Beep

End Sub
Sub Macro4()
'
' Macro4 Macro
' Macro recorded 12/27/2007 by 012697
'
' Keyboard Shortcut: Ctrl+Shift+Z
'
End Sub

"Gary''s Student" wrote:

Put the following macro in the worksheet code area of any worksheet you to
want to "beep-ize":

Private Sub Worksheet_Change(ByVal Target As Range)
Beep
End Sub
--
Gary''s Student - gsnu200762


"ziad" wrote:

I have create a workbook shared with my firends, I want to set up a beep of
bill sound whenever this workbook updated,

Thanks
Ziad