Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.setup
Holsenback
 
Posts: n/a
Default Menu Bar

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Edit Menu will not automatically drop down anymore Irene Pai Excel Discussion (Misc queries) 5 May 12th 11 07:43 AM
Adding buttons to a new menu bar Greegan Excel Worksheet Functions 1 April 7th 06 07:55 AM
Customizing Excel Worksheet Menu Bar without VBA coding Sylvia Excel Discussion (Misc queries) 7 March 22nd 06 06:58 PM
Customizing Worksheet Menu Bar for a workbook without VBA coding Sylvia Excel Discussion (Misc queries) 0 March 20th 06 07:20 AM
Menu items added with menu item editor in older versions Michael Hoffmann Excel Discussion (Misc queries) 2 January 7th 05 01:40 PM


All times are GMT +1. The time now is 03:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"