LinkBack URL
About LinkBacks
How do I add a caption + custom icon for an attached macro/custom control, on the Quick Access Toolbar?
How do I add a caption + custom icon for an attached macro/custom control, on the Quick Access Toolbar?
1. Go to File - Options
2. Select Quick Access Toolbar
3. Under the "Choose Commands from" option, select Macros
4. Select the required macro and hit the Add button
5. Select the button in the right hand frame and select Modify
6. Change the icon to the desired..
I don't know about captions - I'm not sure that it is supported on the QAT
Elegant Simplicity............. Not Always
Thanks AndyLitch for your response,
I know how to attache a macro to "QAT"
My question is a "Caption"
Built-in commands have their familiar icons. BUT custom "macros" are a luck-dip of meaningless cartoons ..!
I have one project with 8 controls applicable to a variety of sheets in the parent project. This is not an XLAM file
The default icons from available list is useless without a caption for CUSTOM macros (Sub procedures)
A green dot (or whatever) does not give the user any clues what the icon represents.
XLSM projects are pointless as a ribbon-tab because the tab remains even after the XLSM file is closed.
The ONLY way I can see to make the custom controls XLSM specific is on the QAT.
Frustrating after 18 years as an Excel/AutoCad addins developer.
Office 2010
http://www.rondebruin.nl/win/s2/win013.htm
The above link has some very useful examples for customising the ribbon which you can make specific to a workbook.
@GreyGhost.
You say the tab remains after the .xlsm file is closed. Is that custom xml or as a result of vba and commandbar creation? The default behaviour for ribbon xml within a .xlsx or .xlsm workbook is to only display when that workbook is active.
You can alter this behaviour by using a different namespace in the xml.
And the QAT is not designed to display captions. It displays icon and screentip.
Thanks Andy Pope for your response
I have been tearing my hair out for weeks trying to find out how Ribbon-Tabs/QAT relate to each other or not.
Specifically the limitations of each and what file types use tabs or QAT
I have been writing VBA for about 18 years + WordBasic before that, so I am used to custom toolbars in Excel and all their foibles. Workbook-Events to ensure toolbars are made available over the parent workbook, etc ...
99% of my controls are CUSTOM actions ... not built-in commands
At the moment if I can get a XLSM files to work ... I will be a happy camper.
ie, One XLSM file with its dedicated controls available to numerous sheets within the project. (Not wsheet controls)I also have a lot of addins (my authorship) that I will wrestle with later. One XLA with 58 custom controls that has worked like a dream since 2004, now it is useless in Excel 2010I am an old Excel 2003 developer, addins, templates etc ... toolbars were straight forward although book-events got busy to ensure toolbars only appeared to parent projects.
It looks like MS threw out the baby and the bath and the water with Excel-2010 (and I assume Excel-2007)
I would appreciate ANY guidance to start understanding where and how custom controls for an XLSM are placed, to ensure dedicated controls to the XLSM project.
At last I now know that QAT controls cannot have Captions. Thank you for the confirmationAnd the QAT is not designed to display captions. It displays icon and screentip.
This is where I glaze over. XML is a brand new experience for me. A lot to learn.You can alter this behaviour by using a different namespace in the xml.
Thank you
Last edited by GreyGhost; 02-10-2014 at 06:55 AM.
AndyLitch's link is a good place to start. Explore Ron's pages on ribbon related stuff.
The is a tool on my site to make this a little easier,
http://www.andypope.info/vba/ribboneditor_2010.htm
More detail and examples here.
http://www.andypope.info/vba/ribboneditor.htm
Bob Phillips has some information on making the process less painful using vba.
http://msmvps.com/blogs/xldynamic/ar...ch-a-pain.aspx
http://msmvps.com/blogs/xldynamic/ar...bbon-code.aspx
Thank you AndyLitch for the link to Ron de Bruin
There is very little info on the web for Excel 2003 developers getting a grip on the ribbon/tabs/QAT in Excel 2010 (2007)
I thought I was going to get to retirement with Excel 2003 and then go fishing. But not so
Thanks again
Andy Pope .. life saver
It is past my bedtime here (OZ)
I will look into all your suggestions tomorrow after I have dealt with mundane things like clients.
Thanks again
LOL........... Good luck M8
For some of my more complex toolbars and custom menus (Excel2003) I used a wsheet table.
I could then add controls without touching code, but it required a lot of coffee to get through the project.
With XML is it possible to use a wsheet table for control types, caption, level etc... an XLT file for any XLS or XLA already setup made new projects a lot simpler.
Took me about 2 years to refine the gliches.
A loop through the table was so easy.
In Excel 2010, are project specific tabs/controls created by the open-event?
No.
An XLMS file is actually a combination of files - one of which specifies the ribbon controls... You have to create that outside of VBA to set your ribbon
It is possible to use dynamic menus with the ribbon where your VBA code will build the required XML string - this may be table-driven.
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
Thank you AndyLitch
I guess XML ???An XLMS file is actually a combination of files - one of which specifies the ribbon controls... You have to create that outside of VBA to set your ribbon
VBA setting XML ??
------------
Thank you Izandol
My Excel 2003 menus (on menubar) are dynamic at all menu levels (where required)
Excel 2003 addins ... With custom menus on menubar I limit sub menus to one level
Please Login or Register to view this content.... I assumed VBA and XML are totally separate entities, like oil and water...VBA code will build the required XML string
I use the table for initial build by Workbook_Open() ... in fact uses a late bound class to build the menu/toolbars. Dynamic adjustments by parent menus
Can you point me to samples of VBA rebuilding the XML code ?
Thank you all for your help
Hi,
After trying to add text under the QAT icons, a search of the net found:
http://www.contextures.com/excelribbonaddcustomtab.html
In watching the example video it looks like their tool only works for 2007 and 2010 excel.
My guess is you need to build a custom tab and put text under the Icons in it.
I'm a little late to this party but will keep looking for a better answer. Many times the feature is simply not available is Excel.
One test is worth a thousand opinions.
Thread to review: http://www.excelforum.com/excel-prog...ibbon-tab.html
Thanks MarvinP and Izandol for your support
I must get some $$ in today, so I will lookinto all the suggestions so far
Thank you all ... I will be back
the-bald-one
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks