Customizing the Ribbon

There are two different menu constructions in the ribbon:

  • Standard: For users who just started to use the application and want to use very basic functions.

  • Advanced: For users who are already familiar with the application and would like to use advanced features or would like to customize it specifically to their needs.

You can insert additional buttons and functions to the ribbon by editing the JChemExcelRibbon.xml file and save it as JChemExcelRibbon_Custom.xml.

Standard and Advanced menu sets cannot be used together with a customized XML file.

It is possible to use Chinese and Japanese ribbon sets with a customized XML file. Please, contact [email protected] regarding this topic.

Customize the Advanced Ribbon

Hide a Button

  1. Open the JChemExcelRibbon.xml file for editing. The default folder is the following:
    C:\Users\<Current User>\AppData\Roaming\ChemAxon\JChem for Excel

  2. Select some buttons which you want to hide from the ribbon, for example, ConvertFromSMILESToStructureAction set its visibility to FALSE.

    <?xml version="1.0" encoding="UTF-8"?>
    <box id="Structure.Convert.Box.From" boxStyle="vertical">
    <button onAction="ConvertFromSMILESToStructureAction" id="ConvertFromSMILESToStructureAction" label="From SMILES" image="ConvertFromSMILESToStructureAction.png" getImage="GetImage" screentip="Convert SMILES string to structure." size="normal" visible="false" getEnabled="OnIsEnabled" />
    <button onAction="ConvertFromShapeAction" id="ConvertFromShapeAction" label="From Image/OLE" image="ConvertFromImage.png" getImage="GetImage" screentip="Convert from any type of Excel shape to structure." size="normal" visible="true" getEnabled="OnIsEnabled" />
    <button onAction="ConvertFromTextToStructureAction" id="ConvertFromTextToStructureAction" label="From 'any' Text" image="ConvertFromText.png" getImage="GetImage" screentip="Convert cell text to structure." size="normal" visible="true" getEnabled="OnIsEnabled" />
    </box>
  3. Save the modified XML file as JChemExcelRibbon_Custom.xml. The default folder is the following:
    C:\Users\<Current User>\AppData\Roaming\ChemAxon\JChem for Excelimages/download/attachments/1807133/Customizing_the_Ribbon_Hide.png

Add a Button

  1. Add some new actions, for example, ConvertToIUPACNameAction to the ribbon. Add the new actions as new rows to a selected section of the JChemExcelRibbon.xml file.

    <?xml version="1.0" encoding="UTF-8"?>
    <box id="Structure.Convert.Box.From" boxStyle="vertical">
    <button onAction="ConvertToIUPACNameAction" id="ConvertToIUPACNameAction" label="To IUPAC" image="IUPAC.png" getImage="GetImage" screentip="Convert structure to IUPAC." size="normal" visible="true" getEnabled="OnIsEnabled" />
    <button onAction="ConvertFromShapeAction" id="ConvertFromShapeAction" label="From Image/OLE" image="ConvertFromImage.png" getImage="GetImage" screentip="Convert from any type of Excel shape to structure." size="normal" visible="true" getEnabled="OnIsEnabled" />
    <button onAction="ConvertFromTextToStructureAction" id="ConvertFromTextToStructureAction" label="From 'any' Text" image="ConvertFromText.png" getImage="GetImage" screentip="Convert cell text to structure." size="normal" visible="true" getEnabled="OnIsEnabled" />
    </box>
  2. Paste an IUPAC.png file into the Images folder to provide an icon for the new buttons. The default folder is the following:
    C:\Users\<Current User>\AppData\Roaming\ChemAxon\JChem for Excel\Images

  3. Save the modified XML file as JChemExcelRibbon_Custom.xml. The default folder is the following:
    C:\Users\<Current User>\AppData\Roaming\ChemAxon\JChem for Excelimages/download/attachments/1807133/Customizing_the_Ribbon_Add.png

The original JChemExcelRibbon.xml file is loaded automatically instead of the customized file when starting Microsoft Excel if there is any problem with the customization.

Personal Customization of the Ribbon in Case of Standard Menu Set

The process is the same as in case of the advanced menu set, but the location of the customized file is different:

C:\Users\<Current User>\AppData\Roaming\ChemAxon\JChem for Excel\Basic

Corporate Level Customization of the Ribbon

The modifications described above must be done in the original JChemExcelRibbon.xml file and it must be re-packed in the installer.