I was doing some VBA when for some reason some menu items are missing. For
instance the Insert Menu does not have the Names menu item any more. Similary
the number of Menu items in Format are much less than normal.
Thanks for your help.
Alok

Tools=Customize

select the first tab, select worksheet menu bar and click the reset button.

--
Regards,
Tom Ogilvy

"Alok" wrote in message
...
I was doing some VBA when for some reason some menu items are missing. For
instance the Insert Menu does not have the Names menu item any more.
Similary
the number of Menu items in Format are much less than normal.
Thanks for your help.
Alok

After you get those toolbars the way you want them (using Tom's suggestion), you
may want to back up the file that holds that info.

Close excel
windows start button|search|*.xlb
Look in hidden folders, too.

The date/time should be pretty current--since you just changed fixed it.

Back up the real one to a nice safe spot. Then when your experiments go wrong,
Doctor, you can just close excel and copy that back up into its real home.

(Remember to make backups when you modify a toolbar for real.)



Alok wrote:

I was doing some VBA when for some reason some menu items are missing. For
instance the Insert Menu does not have the Names menu item any more. Similary
the number of Menu items in Format are much less than normal.
Thanks for your help.
Alok

--

Dave Peterson

Thanks to both Tom and Dave.

What I ended up doing was to go to Tools/Customize and then Commands tab.
Then I selected Built-In Menus on the left and dragged the Insert Menu from
there to the Menu Bar. I then had two Insert Menu items on the Menu bar. I
then right clicked on the older one and deleted it. I did the same for the
Format menu item.

Alok

netscapeXSPAM.com wrote in message
...
After you get those toolbars the way you want them (using Tom's
suggestion), you
may want to back up the file that holds that info.

Close excel
windows start button|search|*.xlb
Look in hidden folders, too.

The date/time should be pretty current--since you just changed fixed it.

Back up the real one to a nice safe spot. Then when your experiments go
wrong,
Doctor, you can just close excel and copy that back up into its real home.

(Remember to make backups when you modify a toolbar for real.)



Alok wrote:

I was doing some VBA when for some reason some menu items are missing.
For
instance the Insert Menu does not have the Names menu item any more.
Similary
the number of Menu items in Format are much less than normal.
Thanks for your help.
Alok

--

Dave Peterson