Did you try Help > Detect and repair ??

or see if this link helps

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

VBA Noob
I can send it you and you can have a try!

Tried all of the above nothing worked! i think i am completly screwed!
Thanks for your help anyway.

Anyone else out there think they could sort it?