View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 923
Default Menu Title code is where?

This is because the menu item has been added using the Excel Customize
Toolbar wizard. There effectively is no code (other than any assigned
macro). The toolbar settings are stored in an .xlb file for the user and
loaded when Excel opens.

Right click on an empty space in the toolbar area and the customize dialog
will open, then right-click the item and you should be able to edit the
name.

--
Cheers
Nigel



wrote in message
...
I have a spreadsheet that has a menu bar item (on the same line with
File, Edit, View etc. ) that is mispelled. I can't find that menu bar
code. I can find the
macros that it points to, but where is the code for the menu bar itself?
Help?