mikerickson
05-22-2008, 09:52 PM
I am writting a UDF. It works good, but it has a "feature" that I would like to change. This is the start of the function.
Function ArrayOfPrecedents(homeCell As Range) As Variant
Dim outRRay As Variant
Dim i As Long, pointer As Long
If homeCell.HasFormula Then
ReDim outRRay(1 To Len(homeCell.Formula))
On Error Resume Next
homeCell.Parent.ClearArrows
homeCell.ShowPrecedents: Rem problem Line
On Error GoTo 0
Rem more code
End Function
If homeCell contains a formula that has precedents (eg. =A1+B1) everything is fine.
If homeCell contains a constant, everything is fine.
If homeCell contains a formula that has no precedents (eg. =TODAY() ) Excel beeps when that line is executed. In addition to annoying me, it also slows execution tremendously.
In other sitations, Excel will sometimes beep at me if I give it bad directions. This is the same audio alert.
Both of these have failed to silence the beep.Application.DisplayAlerts = False
Application.EnableSound = False
Does anyone know how to silence Excel's alert beep?
Thank you.
Function ArrayOfPrecedents(homeCell As Range) As Variant
Dim outRRay As Variant
Dim i As Long, pointer As Long
If homeCell.HasFormula Then
ReDim outRRay(1 To Len(homeCell.Formula))
On Error Resume Next
homeCell.Parent.ClearArrows
homeCell.ShowPrecedents: Rem problem Line
On Error GoTo 0
Rem more code
End Function
If homeCell contains a formula that has precedents (eg. =A1+B1) everything is fine.
If homeCell contains a constant, everything is fine.
If homeCell contains a formula that has no precedents (eg. =TODAY() ) Excel beeps when that line is executed. In addition to annoying me, it also slows execution tremendously.
In other sitations, Excel will sometimes beep at me if I give it bad directions. This is the same audio alert.
Both of these have failed to silence the beep.Application.DisplayAlerts = False
Application.EnableSound = False
Does anyone know how to silence Excel's alert beep?
Thank you.