Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Menu Maker and Excel 2007
Hi all
I see that John Walkenbach's Menu Maker doesn't require much modification to work with the QAT. Is there a similar method for building a custom Ribbon tab or group? Thanks in advance Paul Martin Melbourne, Australia |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Menu Maker and Excel 2007
Hi,
Check out Mike's menu builder for 2007. http://www.datapigtechnologies.com/freeware.htm Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Paul Martin" wrote in message ... Hi all I see that John Walkenbach's Menu Maker doesn't require much modification to work with the QAT. Is there a similar method for building a custom Ribbon tab or group? Thanks in advance Paul Martin Melbourne, Australia |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Menu Maker and Excel 2007
Ron de Bruin has lots of info, too:
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 Paul Martin wrote: Hi all I see that John Walkenbach's Menu Maker doesn't require much modification to work with the QAT. Is there a similar method for building a custom Ribbon tab or group? Thanks in advance Paul Martin Melbourne, Australia -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Menu Maker and Excel 2007
Dave, as far as I can tell, Ron's code is only for the QAT, which I
specifically am NOT interested in. Thanks, Andy, I'll check out Mike's Custom_UI_Builder.xlsm. Paul |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Menu Maker and Excel 2007
Look again.
Ron has lots of instructions for modifying the ribbon, too. Paul Martin wrote: Dave, as far as I can tell, Ron's code is only for the QAT, which I specifically am NOT interested in. Thanks, Andy, I'll check out Mike's Custom_UI_Builder.xlsm. Paul -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Menu Maker and Excel 2007
Thanks, Dave, but I'm looking not just at modifying the Ribbon, but
building some sort of Walkenbach-like Menu Maker. I see that Mike's Custom_UI_Builder is a little crude, but does the trick. It looks like a good starting point. Paul |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Menu Maker and Excel 2007
See also Andy's add-in
http://www.andypope.info/vba/ribboneditor.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Paul Martin" wrote in message ... Thanks, Dave, but I'm looking not just at modifying the Ribbon, but building some sort of Walkenbach-like Menu Maker. I see that Mike's Custom_UI_Builder is a little crude, but does the trick. It looks like a good starting point. Paul |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Menu Maker and Excel 2007
Thanks Ron. Both your's and Andy's work and resources have been
invaluable for me. I've been using Andy's Add-In, but that's not the solution I'm seeking. FWIW, I've been modifying Mike's code to get XML closer to what one expects, using line breaks and tabs, and replace single quotation marks with doubles, etc. I don't have much time to explore this further at present, but I am reasonably happy with this. Regards Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
New Menu tab in Excel 2007 | Excel Programming | |||
Excel 2003 & 2007 menu compatible menu by Ron de Bruin | Excel Programming | |||
Custom Menu in Excel 2007 | Excel Programming | |||
Old Menu in Excel 2007 | Excel Discussion (Misc queries) | |||
Help Me!!!Excel opening File Maker | Excel Programming |