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.[VBA]Application.DisplayAlerts = False
Application.EnableSound = False[/VBA]

Does anyone know how to silence Excel's alert beep?

Thank you.