Hello,

i know this is an old thread.. but maybe someone can help.

In my VBA, I call:

Application.DisplayAlerts = False
Range("A1").ShowDependents

The problem is when there are no dependents Excel will usually show an alert and make a beep sound. Application.DisplayAlerts = False will make the alert go away but the beep sound remains.

Is there a way to remove the beep sound in this case ?

Thanks
shandor