Dave, sorry about taking so long to reply. ended up in hospital but ok now.
You were right about the .xlb's i found an old excel8.xlb. once i removed it
all went back to normal. Thanks for the superb advice. Hope i can return the
favor sometime.