Neither of these is working for me. I lost the "Tools" button. Tried going
to ViewToolbarsCustomize, but it will not let me grab and drag "File" (or
any other words) to the Menu Bar.

Since "Tools" is gone, I obviously can't try the tip involving
ToolsCustomizeToolbars.

If it's any help, "Tools" vanished from my Excel Menu Bar at the same time
it vanished from Word (both programs were open at the time). I had the Word
cursor turn into something weird that looked like a box when I put it up to
any of the Menu Bar buttons, and it made "Tools" disappear from both Word and
Excel. Renaming my "Normal" file brought it back in Word, but not for Excel.


"Gord Dibben" wrote:

Nikki

I think Peo means ViewToolbarsCustomize. From the Built-in Menus grab
hold of the word "File" and drag to the Worksheet Menu Bar.

Another option.........

ToolsCustomizeToolbars. Select Worksheet Menu Bar and "Reset".

NOTE: this will undo any customizations you may have made.

Gord Dibben Excel MVP

On Mon, 18 Oct 2004 14:41:42 -0600, "Peo Sjoblom" wrote:

Fileviewtoolbars and customize, then click command tab, in the left pane
scroll down to built in menus, in the right hand pane grab a hold (with the
lef mouse button) of the word Edit and drag it to where you want it,
release the mouse button, close the customize box

Done!

Regards,

Peo Sjoblom


"Nikki R" <Nikki wrote in message
...
I accidentally grabbed the File menu (as in File / Edit / View / Insert /
Format...) in Excel 97 and dragged it. Now it's disappeared and I can't
figure out how to restore it. Can anyone help please?!?!
THanks!