Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
It's been a rough few days! I've read so much that it starting to
blur and run together! <lol. Anyway, the pressures of the demands at work mean that I must find easier ways to do things to help ease the load. I stumbled on some pages on creating custom pulldown menus but found they were VBA-based ones for the most part (like the menumaker file example with downloadable file he http://www.j-walk.com/ss/excel/tips/tip53.htm). I've not had much success with that because although the example file is there, I just don't know enough vb to make it work. First off, I don't need sub-menus and I don't need as many different types of items either - so right from there, I'm deviating a lot from the example file. I get error messages right away. Then I was lucky enough to stumble on to a manual way of making menus that works like customizing toolbars, something I am extremely familiar with: http://www.cpearson.com/excel/menus.htm The recent problems at work mean that I need to constantly be accessing about 20 files found on different folders on the network. I have shortcuts to the two major ones in my QL but it's getting really old, really fast to have to click through shortcuts elsewhere to get to the rest. It would be easiest if all these files were available in the menu I created called "MyDocts". I was able to add the pulldown in a heartbet following the instructions on the above manual method webpage, but I just can't seem to figure out how to get items onto the menu! The terminology is confusing to me, a newbie to menu issues, but I believe I figured out what the meanings are. From that page above, http://www.cpearson.com/excel/menus.htm : "The procedure for adding a new tool to a command bar is the same, except that you should choose Custom Button rather than Custom Menu Item from the Macros Categories list in the Customize dialog box." I've tried choosing custom button as it says. But I guess that what I do next is wrong. Like customizing the toolbar, we usu. just drag the item. When I try to drag the custom icon to the new "MyDocts" menu, all I achieve is creating another custom menu, this time with a happy face! <lol If I can just get the happy face one to appear as what is available underneath the "MyDocts" menu, I'd have it made. I could then take it from there to assign a macro to each entry. At least, that's what I'm hoping we can do because the other VB way just is so complicated in comparison for me. Thanks so much! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I unlock some menu items? | Excel Worksheet Functions | |||
Menu items | Excel Discussion (Misc queries) | |||
Missing menu items | Setting up and Configuration of Excel | |||
greyed out menu items | Excel Worksheet Functions | |||
Menu items added with menu item editor in older versions | Excel Discussion (Misc queries) |