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
