Use Keyascii = vbKeyTab instead of SendKeys "{TAB}"

This should solve your problem. I remember having that problem. When I want to use the Enter Key but I don't want to hear the 'ding' sound, I use Keyascii = 0. I'm pretty sure your problem will be fixed. Give me some news if it works or not!