Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
Problem solved. Thanks Dave. Ed Holsenback
"Dave Peterson" wrote: 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. Holsenback wrote: 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?? "Dave Peterson" wrote: Did you go to tools|options or Tools|customize??? If tools|options was gone, you can reset that worksheet menu bar. Tools|customize|toolbars tab click on worksheet menu bar and click the reset button. You will have to reapply any customized changes to that toolbar, though. Holsenback wrote: In attempting to prevent automatic recalculation in Excel, I went to Tools, Customize and the Tools optiion disappeared from the menu. How can I restore it? -- Dave Peterson -- Dave Peterson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Edit Menu will not automatically drop down anymore | Excel Discussion (Misc queries) | |||
Adding buttons to a new menu bar | Excel Worksheet Functions | |||
Customizing Excel Worksheet Menu Bar without VBA coding | Excel Discussion (Misc queries) | |||
Customizing Worksheet Menu Bar for a workbook without VBA coding | Excel Discussion (Misc queries) | |||
Menu items added with menu item editor in older versions | Excel Discussion (Misc queries) |