Thread
:
Attaching Custom Menus
View Single Post
#
3
Posted to microsoft.public.excel.programming
John Tolman[_2_]
external usenet poster
Posts: 9
Attaching Custom Menus
I eventually just created a menu and docked it right under the Normal Menu, it'll have to do, although I'll take a look at that code and may use it depending if it ends up seeming to be worth it.
Thanks for the help.
"Andy Wiggins" wrote:
This file might be a help:
http://www.bygsoftware.com/examples/...tiveWbDemo.zip
It's in the "Menu Routines" section on page:
http://www.bygsoftware.com/examples/examples.htm
It contains VBA code that will activate a menu only when the workbook it is
in is active.
The code is open and commented.
--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"
"John Tolman" <John
wrote in message
...
I have read through all the posts I can find on this, and no luck (sort
of).
I would like to avoid having to write VBA code that builds / destroys the
menu each time the file is opened, and other than that, I can not appear to
"attach" the custom menu in the way that I would a tool bar.
I could just creat the menus inside a custom tool bar and dock this up
next to the menu, but I really was trying to get it up there in the actual
menu. I have tried creating the menu in a toolbar and dragging this to the
menu, then attaching the toolbar that I just dragged the menu from, but it
is of course only attaching the blank toolbar.
Is it just that Excel will not allow the custom menus placed in the menu
bar to be attached to a spreadsheet, and I have no choice but to build code
for this purpose?
Let me know, and if there is no way to do this the "easy way", please
reply with a link to a good resource on how to build the code to build /
destroy this menu...
Thanks!
Reply With Quote
John Tolman[_2_]
View Public Profile
Find all posts by John Tolman[_2_]