You should be able to remove the "whoosh" sound the following way if you have enough space in your macro (if its a macro that casts the spell).


/console soundFX 0
/cast Holy Shield
/console soundFX 1