thanks for the help with that.
Ive done anther silly thing, whilst messing around with the tool bar I have managed to remove or delete the 'data' menu in excel. this happened when I was trying to add more toolbar icons etc to the toolbar. For the life of me I cant work out how to get the menu back to what is was before.
Please help, i KNow its PrObAbLy somthing obvious but i cant work it out.
thanks for any and all help.