LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 171
Default Creating menu items without using VBA way?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I unlock some menu items? Grandma Betty Excel Worksheet Functions 6 December 30th 08 09:48 PM
Menu items Pietro Excel Discussion (Misc queries) 2 March 1st 07 10:41 AM
Missing menu items Ken Setting up and Configuration of Excel 3 February 27th 06 07:58 AM
greyed out menu items Jamie Excel Worksheet Functions 0 December 13th 05 05:09 PM
Menu items added with menu item editor in older versions Michael Hoffmann Excel Discussion (Misc queries) 2 January 7th 05 01:40 PM


All times are GMT +1. The time now is 05:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"