Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Attaching Custom Menus
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
New Menus - attaching but menus are reset | Excel Worksheet Functions | |||
Macros in a template run from Custom Toolbar attaching to wrong file. | Excel Programming | |||
custom menus | Excel Programming | |||
Custom Menus | Excel Programming | |||
Attaching Macros to Custom Buttons | Excel Programming |