There should be an answer in here: https://us.forums.blizzard.com/en/wow/t/disable-error-sound-in-macro