At the top of the workbook, I now have File, Edit, View, Insert, Format,
Data, Window and Help. Tools has disappeared. This is true for the entire
Excel program. The function is missing in all of my files??
> Did you go to tools|options or Tools|customize???
>
[quoted text clipped - 9 lines]
> > Customize and the Tools optiion disappeared from the menu. How can I restore
> > it?
Dave Peterson - 21 Apr 2006 13:59 GMT
Resetting the worksheet menu bar didn't remove the Tools dropdown.
But you can reset all the toolbars if you want:
close excel
windows search
search for *.xlb
(in hidden folders for hidden files, too)
Rename all the *.xlb files you find to *.xlbOLD
Then restart excel and see if that helps.
If it does, then rebuild any customized changes to the toolbar at your
convenience.
If it doesn't, then close excel and rename all those *.xlbOLD back to *.xlb.
> At the top of the workbook, I now have File, Edit, View, Insert, Format,
> Data, Window and Help. Tools has disappeared. This is true for the entire
[quoted text clipped - 17 lines]
> >
> > Dave Peterson

Signature
Dave Peterson
Holsenback - 21 Apr 2006 15:03 GMT
Problem solved. Thanks Dave. Ed Holsenback
> Resetting the worksheet menu bar didn't remove the Tools dropdown.
>
[quoted text clipped - 35 lines]
> > >
> > > Dave Peterson