View Single Post
  #15   Report Post  
Posted to microsoft.public.excel.programming
StargateFan[_3_] StargateFan[_3_] is offline
external usenet poster
 
Posts: 171
Default Creating menu items without using VBA way?

On Fri, 25 Jun 2004 01:36:28 GMT, Andy wrote:

Also, what I liked about the manual technique is that I can
arrange the files as I like very easily.


How do you get filenames on the Custom Menu Item?


After putting the NEW MENU item along the top, I right-clicked and saw
there was a spot to rename just like in a toolbar entry. So this is
process: I right-click on any toolbar and select customize (or you
can click TOOLS CUSTOMIZE). From the commands tab, under categories
box I'll scroll down to choose NEW MENU and then in the Commands
window will drag up the NEW MENU option. Once the NEW MENU appears
along the top, I'll right-blick on it and where it says name, the
default NEW NAME appears. I'll just type over that and put something
like "My Doc&uments". The ampersand, &, as you probably know, gives
one keyboard access to this command so that one could also just press
Alt then "u" to this menu.

Then I've added items by choosing MACROS from the commands window and
dragging up the CUSTOM BUTTON smiley face to the new menu which when
you drag near it, pops up a square box just ready to receive entries!
<g Very awesome, this. I'm sure glad I learned how to do this.

Oh, so this will work with Word, too?? I'll have to give it a
try. I only used it on Excel but it has 2 major glitches with it.

Unless you're speaking of another add-in?? If so, can you provide
a link to that?


It's not an add-in, it's a built in Word menu. But it's not on
the menu bar by default, you have to put it there. In the Customize
dialog, under Built In Menus, it's the Work menu.

But there's no built-in way to get files *off* the menu. I put the
"Remove Menu Shortcut" command right on the Work menu. But watch out
for that bold minus sign! It's dangerous! It will remove anything
from a menu, not just filenames from the Work menu.