Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing New Menu code
After interactively adding a menu item (tools/customize/commands/new menu) to
the excel toolbar is the code available to edit? I've created a layered menu but I can't seem to find the resulting code. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing New Menu code
hi
custom menu item and custom icons have macros assigned to them. the code should be in the vb editor somewhere. Alt+F11. regards FSt1 "rnosk" wrote: After interactively adding a menu item (tools/customize/commands/new menu) to the excel toolbar is the code available to edit? I've created a layered menu but I can't seem to find the resulting code. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing New Menu code
That's what I thought but I'm not seeing the resulting code. I don't know if
its hidden or specifically not made available. I can certainly write VB to produce the menu but I would get a jump start if this code was available. "FSt1" wrote: hi custom menu item and custom icons have macros assigned to them. the code should be in the vb editor somewhere. Alt+F11. regards FSt1 "rnosk" wrote: After interactively adding a menu item (tools/customize/commands/new menu) to the excel toolbar is the code available to edit? I've created a layered menu but I can't seem to find the resulting code. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing New Menu code
I think it's better to do all the work in code.
For additions to the worksheet menu bar, I really like the way John Walkenbach does it in his menumaker workbook: http://j-walk.com/ss/excel/tips/tip53.htm Here's how I do it when I want a toolbar: http://www.contextures.com/xlToolbar02.html (from Debra Dalgleish's site) And if you use xl2007: If you want to learn about modifying the ribbon, you can start at Ron de Bruin's site: http://www.rondebruin.nl/ribbon.htm http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an addin) or http://www.rondebruin.nl/2007addin.htm In xl2007, those toolbars and menu modifications will show up under the addins. rnosk wrote: After interactively adding a menu item (tools/customize/commands/new menu) to the excel toolbar is the code available to edit? I've created a layered menu but I can't seem to find the resulting code. -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing New Menu code
Thanks Dave. I suppose I can't cut corners by using the code generated while
I did the interactive version. Your links were helpful. "Dave Peterson" wrote: I think it's better to do all the work in code. For additions to the worksheet menu bar, I really like the way John Walkenbach does it in his menumaker workbook: http://j-walk.com/ss/excel/tips/tip53.htm Here's how I do it when I want a toolbar: http://www.contextures.com/xlToolbar02.html (from Debra Dalgleish's site) And if you use xl2007: If you want to learn about modifying the ribbon, you can start at Ron de Bruin's site: http://www.rondebruin.nl/ribbon.htm http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an addin) or http://www.rondebruin.nl/2007addin.htm In xl2007, those toolbars and menu modifications will show up under the addins. rnosk wrote: After interactively adding a menu item (tools/customize/commands/new menu) to the excel toolbar is the code available to edit? I've created a layered menu but I can't seem to find the resulting code. -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing New Menu code
Maybe or maybe not.
Depends on what that code was. rnosk wrote: Thanks Dave. I suppose I can't cut corners by using the code generated while I did the interactive version. Your links were helpful. "Dave Peterson" wrote: I think it's better to do all the work in code. For additions to the worksheet menu bar, I really like the way John Walkenbach does it in his menumaker workbook: http://j-walk.com/ss/excel/tips/tip53.htm Here's how I do it when I want a toolbar: http://www.contextures.com/xlToolbar02.html (from Debra Dalgleish's site) And if you use xl2007: If you want to learn about modifying the ribbon, you can start at Ron de Bruin's site: http://www.rondebruin.nl/ribbon.htm http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an addin) or http://www.rondebruin.nl/2007addin.htm In xl2007, those toolbars and menu modifications will show up under the addins. rnosk wrote: After interactively adding a menu item (tools/customize/commands/new menu) to the excel toolbar is the code available to edit? I've created a layered menu but I can't seem to find the resulting code. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop users from accessing "Protection" option from "Tools" menu | Excel Programming | |||
Accessing Menu Options from VB Code | Excel Programming | |||
Menu Item Action Changes with "User" accessing file | Excel Programming | |||
Accessing Addin from Sheet_Event Code | Excel Programming | |||
Accessing Addin from Sheet_Event Code | Excel Programming |