Did you try Help > Detect and repair ??

or see if this link helps

http://www.excelforum.com/showthread.php?t=592569

VBA Noob