Excel Ribbon Menu - creation - help needed

[Dhamo]

Hi,


I have written few codes which will be used by all my team mates. And I would like to give the code as addin(xla) with ribbon options. So that, after installing that add-in whenever they can use in a single click.


I have around 7 different codes, I need 7 new buttons with button images. I already have created this some time ago. but I couldn't create custom button options. Any help would be much appreciated.


- Dhamo

 

[Debraj]

Install 2010 + Excel.. Not in Excel 2007..


In Excel 2007.. Use QAT..for this Workbook Option

 

[NARAYANK991]

Hi ,


You will find a lot of information here ;


http://www.rondebruin.nl/tips.htm


Narayan

 

[Dhamo]

Thanks DB and Narayan.


The button in Ribbon is working fine if I have full code in Module. But getting error if i call a user form from the module.


Module Sample code:


Sub Pop_S_nO(control As IRibbonControl)

Pop_SNo_Uf.Show vbModeless

End Sub


In User form, the code will populate serial numbers for all used area.


Error: "Cannot run the macro 'Pop_S_No' The Macro may be not available in this workbook or all macros disabled.".


Please help.

 

[Dhamo]

XML Code: <button id="customButton1" label="Serial Number" size="normal" onAction="Pop_S_nO" imageMso="AccountMenu" />


Also I changed the file format as add-in (*xla).


Please reply if you need more details.

 

[spreadsheet1]

Finding the best image suited for a custom control is not that easy, as there are about 4,000 unique icons in Office 2013.

This free-UNLOCKED Excel VBA Add-in uses the Ribbon Commander framework to display dynamically built-in imageMSO icons or imported images in Excel's Ribbon (in buttons or gallery items). What you see, is what you get in your Ribbon !

The imageMSO or any image list can be filtered using with a description keyword search or can be browsed sequentially in a ribbon gallery.

The descriptions of any buttons clicked are saved in a list, which can be exported for use with the Custom UI editor or re-imported to the Add-in for viewing.


See more at: http://www.spreadsheet1.com/dynamic-icon-browser.html