How in the heck can I turn off the STUPID excel sounds on the mac version? ARgh...any help appreciated as I'm currently going crazy with this.

How about Prefs -> General -> Provide feedback with sound?

I could just hug you! Thanks!