so searched google for info on this (found how to make menu items but not how to make a menu Name). would like it to appear after the Help menu.
below is code to make the menu items:
checked out chip's site, microsoft and others
Please Login or Register to view this content.
tried this in the immediate window (with no success)
can someone point me in the right direction so that i can create a menu in the VB editor?Please Login or Register to view this content.
If you include this in your Workbook open event it will add the menu and submenu items.
You then need to use Chip's event handling code to capture the clicks.
I would also incorporate the use of the Tag property to make it easier to remove the items on close
Please Login or Register to view this content.
thanks andy that did the trick.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks