Disable "Trace Dependents" popup

Is it possible to disable the "Trace Dependents" popup, which alerts me that "The Trace Dependents command found no formulas that refer to the active cell".

I want a nice beep instead of the rather annoying popup box..


-thanks

Hi

Would this help

sub auto_open
Application.DisplayAlerts = False
Beep
End Sub

Hi,

Thanks for the input. Sadly, it didn't do the trick..

Regards,
-Tracy

Hi Tracy

Not sure if this will work, but you can try this
Private Sub Workbook_Open()
Application.CommandBars("Worksheet Menu Bar").Controls("Tools").Controls("Auditing").Enabled = False
End Sub

Private Sub Workbook_Close()
Application.CommandBars("Worksheet Menu Bar").Controls("Tools").Controls("Auditing").Enabled = True
End Sub