B
bc_man
I have created a Ribbon and everything was working fine until the last button
was added then I got the macro not available error. I have all my trust
settings wide open. Is there a limit to the number of items that can be
added to a ribbon.
Here is my XML
The error happens on anything below Character Count
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" >
<ribbon >
<tabs >
<tab
id="Tab2"
label="RPExcel07">
<group id="Group1" >
<menu
id="Menu1"
label="Update">
<button
id="UpdateOneCol"
label="Mtch 1 Col Upd 1 Col"
onAction="UpdateOneCol_onAction"/>
<button
id="UpdateTwoCol"
label="Mtch 1 Col Upd 2 Col"
onAction="UpdateTwoCol_onAction"/>
<button
id="MtchOneUpdInpNum"
label="Mtch 1 Col Upd Many Col"
onAction="MtchOneUpdInpNum_onAction"/>
<menuSeparator id="Menuseparator1" />
<button
id="Mtch2Upd1"
label="Mtch 2 Col Upd 1 Col"
onAction="Mtch2Upd1_onAction"/>
<button
id="mtch2update2"
label="Mtch 2 Col Upd 2 Col"
onAction="mtch2update2_onAction"/>
<button
id="mtch2upd4"
label="Mtch 2 Col Upd 4 Col"
onAction="mtch2upd4_onAction"/>
<button
id="MtchTwoUpdInpNum"
label="Mtch 2 Col Upd Many Col"
onAction="MtchTwoUpdInpNum_onAction"/>
<menuSeparator id="Menuseparator2" />
<button
id="Mtch3Upd1"
label="Mtch 3 Col Upd 1 Col"
onAction="Mtch3Upd1_onAction"/>
<button
id="Match3UpdateMany"
label="Mtch 3 Col Upd Many Col"
onAction="Match3UpdateMany_onAction"/>
<menuSeparator id="Menuseparator3" />
<button
id="UpdatePreCode"
label="Mtch 1 Col Upd 1 Col On Left"
onAction="UpdatePreCode_onAction"/>
<button
id="Mtch1ColReplaceWith1Col"
label="Mtch 1 Col ReplaceWith 1 Col"
onAction="Mtch1ColReplaceWith1Col_onAction"/>
</menu >
<menu
id="Menu2"
label="Add">
<button
id="InsertCompForm"
label="Compare (2 columns to the left) Formula"
onAction="InsertCompForm_onAction"/>
<button
id="EntryNumber"
label="Entry Numbers"
onAction="EntryNumber_onAction"/>
<button
id="AddText"
label="Text to selected cells (Cntl+Shft+A)"
onAction="AddText_onAction"/>
<button
id="rowexpand2"
label="Range Plot coordinates"
onAction="rowexpand2_onAction"/>
<button
id="sepsource"
label="Spaces to Source name"
onAction="sepsource_onAction"/>
</menu >
<menu
id="Menu3"
label="Convert">
<button
id="BarcodeWriter_RP"
label="Cell Values to Barcodes (C128M)"
onAction="BarcodeWriter_RP_onAction"/>
<button
id="ConvertTextNumToNumFormat"
label="Text Num To Num Format (Cntl+Shft+N)"
onAction="ConvertTextNumToNumFormat_onAction"/>
<button
id="ConvertNumToTxtFormat"
label="Num To Text Format (Cntl+Shft+T)"
onAction="ConvertNumToTxtFormat_onAction"/>
<button
id="ConvertFromJulian"
label="Julian numeric to Gregorian date"
onAction="ConvertFromJulian_onAction"/>
<button
id="ConvertToJulian"
label="Gregorian date to Julian numeric"
onAction="ConvertToJulian_onAction"/>
</menu >
<menu
id="copymenu"
label="Copy">
<button
id="CopyDownMacro"
label="Copy Down to current cell (Cntl+Shft+C)"
onAction="CopyDownMacro_onAction"/>
<button
id="ExpandRows"
label="Expand/Duplicate Rows"
onAction="ExpandRows_onAction"/>
<button
id="ExpandRows_CustomByLine"
label="Expand/Duplicate Rows - custom by line"
onAction="ExpandRows_CustomByLine_onAction"/>
</menu >
<menu
id="Menu5"
label="COSTARS">
<button
id="COSTARS_DESC"
label="Build Description (Cntl+Shft+D)"
onAction="COSTARS_DESC_onAction"/>
<button
id="sbCOSTARSCheckIn"
label="Check In / Scan Packets [RngPltLoc] (Cntl+Shft+R)"
onAction="sbCOSTARSCheckIn_onAction"/>
<button
id="sbCOSTARSCheckIn_soy"
label="Check In / Scan Packets [EUID] (Cntl+Shft+E)"
onAction="sbCOSTARSCheckIn_soy_onAction"/>
<button
id="OpenCostarsCheckInDoc"
label="Check In / Scan Packets Instructions"
onAction="OpenCostarsCheckInDoc_onAction"/>
</menu >
<menu
id="Menu6"
label="CREATE">
<button
id="BuildInString"
label="Comma-separated 256 character strings from list"
onAction="BuildInString_onAction"/>
<button
id="CustomColumnArrange"
label="Custom Column Arrangement"
onAction="CustomColumnArrange_onAction"/>
<button
id="diallel2col"
label="Diallel from 2 columns of inbreds"
onAction="diallel2col_onAction"/>
<button
id="InvokeEarExpand"
label="Ear Expand Template"
onAction="InvokeEarExpand_onAction"/>
<button
id="OpenListFiles"
label="File List from Folder"
onAction="OpenListFiles_onAction"/>
<button
id="Make_Paper_Folder"
label="Project Folder"
onAction="Make_Paper_Folder_onAction"/>
<button
id="RandNumGen"
label="Random number values"
onAction="RandNumGen_onAction"/>
</menu >
<menu
id="Menu7"
label="DUPLICATES">
<button
id="NewDup_Mark"
label="DupMark Unsorted List"
onAction="NewDup_Mark_onAction"/>
<button
id="NewDup_Mark_All"
label="DupMark Unsorted List- All Occurrences"
onAction="NewDup_Mark_All_onAction"/>
<button
id="newdupout"
label="DupOut Unsorted List"
onAction="newdupout_onAction"/>
<button
id="DupOutOrig_Mark"
label="DupMark Sorted List"
onAction="DupOutOrig_Mark_onAction"/>
<button
id="DupSorted_MarkAll"
label="DupMark Sorted List- All Occurrences"
onAction="DupSorted_MarkAll_onAction"/>
<button
id="DupOut_orig"
label="DupOut Sorted List"
onAction="DupOut_orig_onAction"/>
<button
id="DupOutOrig_Count"
label="DupOut_Count Sorted List"
onAction="DupOutOrig_Count_onAction"/>
<button
id="DupOut_Except"
label="Remove_Except"
onAction="DupOut_Except_onAction"/>
<button
id="DupOut_RemoveOnly"
label="Remove_Only"
onAction="DupOut_RemoveOnly_onAction"/>
</menu >
<menu
id="Menu8"
label="GROUPING">
<button
id="Group"
label="Group within sorted column"
onAction="Group_onAction"/>
<button
id="GroupAndNumber"
label="Group and count the number of groups"
onAction="GroupAndNumber_onAction"/>
<button
id="Ungroup"
label="Ungroup"
onAction="Ungroup_onAction"/>
<button
id="FILLin"
label="Fill In Blanks from grouping (or pivoting)"
onAction="FILLin_onAction"/>
<button
id="Group_Underline"
label="Group and underline"
onAction="Group_Underline_onAction"/>
<button
id="Group_Underline_Nrecords"
label="Group and underline N records"
onAction="Group_Underline_Nrecords_onAction"/>
<button
id="Group_PageBreak"
label="Group and insert page break"
onAction="Group_PageBreak_onAction"/>
<button
id="GroupFirstTotalSecond"
label="Group 1st column, subtotal 2nd column"
onAction="GroupFirstTotalSecond_onAction"/>
<button
id="GroupFirstAverageSecond"
label="Group 1st column, average 2nd column"
onAction="GroupFirstAverageSecond_onAction"/>
<button
id="GroupTwoTotalThird"
label="Group 2 columns, subtotal 3rd column"
onAction="GroupTwoTotalThird_onAction"/>
</menu >
<menu
id="Menu9"
label="MAPS">
<button
id="MapDialog"
label="Location Map from existing worksheet (Cntl+Shft+M)"
onAction="MapDialog_onAction"/>
</menu >
<menu
id="Menu10"
label="MARK">
<button
id="MarkFilteredColumns"
label="Mark Filtered Columns (Cntl+Shft+F)"
onAction="MarkFilteredColumns_onAction"/>
<button
id="MarkInput_String"
label="Mark Input String"
onAction="MarkInput_String_onAction"/>
</menu >
<menu
id="Menu11"
label="PAGE SETUP">
<button
id="PageFormatMaxPortrait"
label="Portrait - Maximum (L,R=0.25"", T,B=0.5"",
H,F=0.3""
"
onAction="PageFormatMaxPortrait_onAction"/>
<button
id="PageFormatMaxWidePortrait"
label="Portrait - Max Fit Width (L,R=0.25"", T,B=0.
5"", H,F=0.3"""
onAction="PageFormatMaxWidePortrait_onAction"/>
<button
id="PageFormatMaxLandscape"
label="Landscape - Maximum (L,R=0.25"", T,B=0.5"",
H,F=0.3"""
onAction="PageFormatMaxLandscape_onAction"/>
<button
id="PageFormatMaxWideLandscape"
label="Landscape - Max Fit Width (L,R=0.25"", T,B=0.
5"", H,F=0.3"""
onAction="PageFormatMaxWideLandscape_onAction"/>
</menu >
<menu
id="Menu12"
label="PEDIGREES">
<button
id="MarkNonAlphaPeds"
label="Mark non-alphabetic pedigrees"
onAction="MarkNonAlphaPeds_onAction"/>
<button
id="CorrectSinglePeds"
label="Reverse Parents within selected pedigrees (Cntl+Shft+Z)"
onAction="CorrectSinglePeds_onAction"/>
<button
id="ParsePed"
label="Parse Pedigrees to columns"
onAction="ParsePed_onAction"/>
</menu >
<menu
id="Menu15"
label="PRISM GROUP IMPORT FORMATS">
<button
id="AOIGrpLoad"
label="AOI Group Import"
onAction="AOIGrpLoad_onAction"/>
<button
id="ExptGrpLoad"
label="Experiment Group Import"
onAction="ExptGrpLoad_onAction"/>
<button
id="GEGrpLoad"
label="GE Group Import"
onAction="GEGrpLoad_onAction"/>
<button
id="GEPrsLoad"
label="GE Pair List Import"
onAction="GEPrsLoad_onAction"/>
</menu >
<menu
id="Menu16"
label="PRISM LINKS">
<button
id="OpenLink_COSTARS"
label="WWS"
onAction="OpenLink_COSTARS_onAction"/>
<button
id="OpenLink_Hyperion"
label="Hyperion (Brio) Reports"
onAction="OpenLink_Hyperion_onAction"/>
<button
id="OpenPDAsuite"
label="PDA Data Collection Suite"
onAction="OpenPDAsuite_onAction"/>
<button
id="OpenPhyto"
label="Phytosanitary"
onAction="OpenPhyto_onAction"/>
<button
id="OpenLink_PRISMFldMnl"
label="PRISM Field Manual"
onAction="OpenLink_PRISMFldMnl_onAction"/>
<button
id="OpenLink_PRISMweb"
label="PRISMweb"
onAction="OpenLink_PRISMweb_onAction"/>
<button
id="OpenLink_PRISMQuickRpt"
label="QuickReports"
onAction="OpenLink_PRISMQuickRpt_onAction"/>
<button
id="OpenLink_RegCompliance"
label="RegCompliance"
onAction="OpenLink_RegCompliance_onAction"/>
<button
id="OpenLink_IM"
label="IM --> My Web Applications"
onAction="OpenLink_IM_onAction"/>
<button
id="OpenLink_CGRD"
label="RIM: CGR+D Systems menu"
onAction="OpenLink_CGRD_onAction"/>
<button
id="OpenLink_RIMCrop"
label="RIM Crop Updates"
onAction="OpenLink_RIMCrop_onAction"/>
</menu >
<menu
id="Menu17"
label="PRISM TEMPLATES">
<button
id="OpenADCS"
label="Area Data Collection Spreadsheet (ADCS)"
onAction="OpenADCS_onAction"/>
<button
id="OpenNCBFList"
label="Nursery Experiment Location Add Template"
onAction="OpenNCBFList_onAction"/>
<button
id="OpenDCTList"
label="Yield Test Experiment Location Add Template"
onAction="OpenDCTList_onAction"/>
<button
id="OpenGENameMaint"
label="GE Name Maintenance"
onAction="OpenGENameMaint_onAction"/>
<button
id="OpenSIAdd"
label="Seed Inventory Add"
onAction="OpenSIAdd_onAction"/>
<button
id="OpenSIUpd"
label="Seed Inventory Update"
onAction="OpenSIUpd_onAction"/>
<button
id="OpenSIFind"
label="Seed Inventory Find Criteria"
onAction="OpenSIFind_onAction"/>
<button
id="OpenSIIDFind"
label="Seed Inventory ID Find Criteria"
onAction="OpenSIIDFind_onAction"/>
</menu >
<menu
id="Menu18"
label="PRISM UTILITES">
<button
id="FixEUTraitNames"
label="Abbreviate 'EU TraitName (uom)' >
'TraitName' [col hd]"
onAction="FixEUTraitNames_onAction"/>
<button
id="FixTraitColumns"
label="Format Trait Export Columns/Report - Landscape"
onAction="FixTraitColumns_onAction"/>
<button
id="BuildInString1"
label="IN' String Builder"
onAction="BuildInString1_onAction"/>
<button
id="DeleteBlankDataCols"
label="List/Delete Columns Without Data"
onAction="DeleteBlankDataCols_onAction"/>
<button
id="DelRowsExceptHeader"
label="Remove All Rows Except Row 1"
onAction="DelRowsExceptHeader_onAction"/>
<button
id="RemoveHapHyperlinks"
label="Remove Haploid Hyperlinks"
onAction="RemoveHapHyperlinks_onAction"/>
<button
id="SelectWordArt"
label="Select All WordArt Labels"
onAction="SelectWordArt_onAction"/>
<button
id="UnprotPIsheet"
label="Unprotect PI Spreadsheet"
onAction="UnprotPIsheet_onAction"/>
<button
id="DisplaySerpForm"
label="Range Plot Sort"
onAction="DisplaySerpForm_onAction"/>
</menu >
<menu
id="Menu19"
label="RPExcel2007">
<button
id="OpenHelpDoc"
label="Help Documentation"
onAction="OpenHelpDoc_onAction"/>
<button
id="This_Version"
label="Version"
onAction="This_Version_onAction"/>
</menu >
<separator id="Separator2" />
<button
id="OpenRPTAGS"
label="RPTAGS"
onAction="OpenRPTAGS_onAction"/>
<button
id="Transposer"
label="Transpose Multiple Columns to Rows"
onAction="Transposer_onAction"/>
<button
id="AutoFitAll"
label="Autofit All Columns"
onAction="AutoFitAll_onAction"/>
<button
id="ChartDataLabeler"
label="Chart Data Labeler"
supertip="(Cntl+Shft+L)"
onAction="ChartDataLabeler_onAction"/>
<button
id="OpenGPSCalc"
label="GPS Area Calculator Template"
onAction="OpenGPSCalc_onAction"/>
<button
id="OpenHyper"
label="Hybrid Parent Trait Summary Report"
onAction="OpenHyper_onAction"/>
<separator id="Separator1" />
<menu
id="Menu20"
label="Rows and Columns"
supertip="Join rows or columns, insert blank rows">
<button
id="JoinCols"
label="Join Columns"
onAction="JoinCols_onAction"/>
<button
id="MrgRows"
label="Merge Rows"
onAction="MrgRows_onAction"/>
<button
id="InsertBlanks"
label="Insert Blank Rows"
onAction="InsertBlanks_onAction"/>
</menu >
<menu
id="Menu21"
label="Files">
<button
id="compExcelFiles"
label="Compare Excel Worksheets"
supertip="Compare 2 Excel Worksheets"
onAction="compExcelFiles_onAction"/>
<button
id="mrgcsv"
label="Merge CSV Files"
supertip="Merge all CSV files in a folder"
onAction="mrgcsv_onAction"/>
</menu >
<menu
id="Menu22"
label="Text">
<button
id="delLeading"
label="Remove Leading Characters"
onAction="delLeading_onAction"/>
<button
id="delEnding"
label="Remove Ending Characters"
onAction="delEnding_onAction"/>
<button
id="CharCount"
label="Character Count"
supertip="Counts characters in the selected cells"
onAction="CharCount_onAction"/>
<button
id="butCleantext"
label="Clean Up Text"
supertip="This function will remove a non printable characters from
the selected text"
onAction="butCleantext_onAction"/>
</menu >
</group >
</tab >
</tabs >
</ribbon >
</customUI >
was added then I got the macro not available error. I have all my trust
settings wide open. Is there a limit to the number of items that can be
added to a ribbon.
Here is my XML
The error happens on anything below Character Count
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" >
<ribbon >
<tabs >
<tab
id="Tab2"
label="RPExcel07">
<group id="Group1" >
<menu
id="Menu1"
label="Update">
<button
id="UpdateOneCol"
label="Mtch 1 Col Upd 1 Col"
onAction="UpdateOneCol_onAction"/>
<button
id="UpdateTwoCol"
label="Mtch 1 Col Upd 2 Col"
onAction="UpdateTwoCol_onAction"/>
<button
id="MtchOneUpdInpNum"
label="Mtch 1 Col Upd Many Col"
onAction="MtchOneUpdInpNum_onAction"/>
<menuSeparator id="Menuseparator1" />
<button
id="Mtch2Upd1"
label="Mtch 2 Col Upd 1 Col"
onAction="Mtch2Upd1_onAction"/>
<button
id="mtch2update2"
label="Mtch 2 Col Upd 2 Col"
onAction="mtch2update2_onAction"/>
<button
id="mtch2upd4"
label="Mtch 2 Col Upd 4 Col"
onAction="mtch2upd4_onAction"/>
<button
id="MtchTwoUpdInpNum"
label="Mtch 2 Col Upd Many Col"
onAction="MtchTwoUpdInpNum_onAction"/>
<menuSeparator id="Menuseparator2" />
<button
id="Mtch3Upd1"
label="Mtch 3 Col Upd 1 Col"
onAction="Mtch3Upd1_onAction"/>
<button
id="Match3UpdateMany"
label="Mtch 3 Col Upd Many Col"
onAction="Match3UpdateMany_onAction"/>
<menuSeparator id="Menuseparator3" />
<button
id="UpdatePreCode"
label="Mtch 1 Col Upd 1 Col On Left"
onAction="UpdatePreCode_onAction"/>
<button
id="Mtch1ColReplaceWith1Col"
label="Mtch 1 Col ReplaceWith 1 Col"
onAction="Mtch1ColReplaceWith1Col_onAction"/>
</menu >
<menu
id="Menu2"
label="Add">
<button
id="InsertCompForm"
label="Compare (2 columns to the left) Formula"
onAction="InsertCompForm_onAction"/>
<button
id="EntryNumber"
label="Entry Numbers"
onAction="EntryNumber_onAction"/>
<button
id="AddText"
label="Text to selected cells (Cntl+Shft+A)"
onAction="AddText_onAction"/>
<button
id="rowexpand2"
label="Range Plot coordinates"
onAction="rowexpand2_onAction"/>
<button
id="sepsource"
label="Spaces to Source name"
onAction="sepsource_onAction"/>
</menu >
<menu
id="Menu3"
label="Convert">
<button
id="BarcodeWriter_RP"
label="Cell Values to Barcodes (C128M)"
onAction="BarcodeWriter_RP_onAction"/>
<button
id="ConvertTextNumToNumFormat"
label="Text Num To Num Format (Cntl+Shft+N)"
onAction="ConvertTextNumToNumFormat_onAction"/>
<button
id="ConvertNumToTxtFormat"
label="Num To Text Format (Cntl+Shft+T)"
onAction="ConvertNumToTxtFormat_onAction"/>
<button
id="ConvertFromJulian"
label="Julian numeric to Gregorian date"
onAction="ConvertFromJulian_onAction"/>
<button
id="ConvertToJulian"
label="Gregorian date to Julian numeric"
onAction="ConvertToJulian_onAction"/>
</menu >
<menu
id="copymenu"
label="Copy">
<button
id="CopyDownMacro"
label="Copy Down to current cell (Cntl+Shft+C)"
onAction="CopyDownMacro_onAction"/>
<button
id="ExpandRows"
label="Expand/Duplicate Rows"
onAction="ExpandRows_onAction"/>
<button
id="ExpandRows_CustomByLine"
label="Expand/Duplicate Rows - custom by line"
onAction="ExpandRows_CustomByLine_onAction"/>
</menu >
<menu
id="Menu5"
label="COSTARS">
<button
id="COSTARS_DESC"
label="Build Description (Cntl+Shft+D)"
onAction="COSTARS_DESC_onAction"/>
<button
id="sbCOSTARSCheckIn"
label="Check In / Scan Packets [RngPltLoc] (Cntl+Shft+R)"
onAction="sbCOSTARSCheckIn_onAction"/>
<button
id="sbCOSTARSCheckIn_soy"
label="Check In / Scan Packets [EUID] (Cntl+Shft+E)"
onAction="sbCOSTARSCheckIn_soy_onAction"/>
<button
id="OpenCostarsCheckInDoc"
label="Check In / Scan Packets Instructions"
onAction="OpenCostarsCheckInDoc_onAction"/>
</menu >
<menu
id="Menu6"
label="CREATE">
<button
id="BuildInString"
label="Comma-separated 256 character strings from list"
onAction="BuildInString_onAction"/>
<button
id="CustomColumnArrange"
label="Custom Column Arrangement"
onAction="CustomColumnArrange_onAction"/>
<button
id="diallel2col"
label="Diallel from 2 columns of inbreds"
onAction="diallel2col_onAction"/>
<button
id="InvokeEarExpand"
label="Ear Expand Template"
onAction="InvokeEarExpand_onAction"/>
<button
id="OpenListFiles"
label="File List from Folder"
onAction="OpenListFiles_onAction"/>
<button
id="Make_Paper_Folder"
label="Project Folder"
onAction="Make_Paper_Folder_onAction"/>
<button
id="RandNumGen"
label="Random number values"
onAction="RandNumGen_onAction"/>
</menu >
<menu
id="Menu7"
label="DUPLICATES">
<button
id="NewDup_Mark"
label="DupMark Unsorted List"
onAction="NewDup_Mark_onAction"/>
<button
id="NewDup_Mark_All"
label="DupMark Unsorted List- All Occurrences"
onAction="NewDup_Mark_All_onAction"/>
<button
id="newdupout"
label="DupOut Unsorted List"
onAction="newdupout_onAction"/>
<button
id="DupOutOrig_Mark"
label="DupMark Sorted List"
onAction="DupOutOrig_Mark_onAction"/>
<button
id="DupSorted_MarkAll"
label="DupMark Sorted List- All Occurrences"
onAction="DupSorted_MarkAll_onAction"/>
<button
id="DupOut_orig"
label="DupOut Sorted List"
onAction="DupOut_orig_onAction"/>
<button
id="DupOutOrig_Count"
label="DupOut_Count Sorted List"
onAction="DupOutOrig_Count_onAction"/>
<button
id="DupOut_Except"
label="Remove_Except"
onAction="DupOut_Except_onAction"/>
<button
id="DupOut_RemoveOnly"
label="Remove_Only"
onAction="DupOut_RemoveOnly_onAction"/>
</menu >
<menu
id="Menu8"
label="GROUPING">
<button
id="Group"
label="Group within sorted column"
onAction="Group_onAction"/>
<button
id="GroupAndNumber"
label="Group and count the number of groups"
onAction="GroupAndNumber_onAction"/>
<button
id="Ungroup"
label="Ungroup"
onAction="Ungroup_onAction"/>
<button
id="FILLin"
label="Fill In Blanks from grouping (or pivoting)"
onAction="FILLin_onAction"/>
<button
id="Group_Underline"
label="Group and underline"
onAction="Group_Underline_onAction"/>
<button
id="Group_Underline_Nrecords"
label="Group and underline N records"
onAction="Group_Underline_Nrecords_onAction"/>
<button
id="Group_PageBreak"
label="Group and insert page break"
onAction="Group_PageBreak_onAction"/>
<button
id="GroupFirstTotalSecond"
label="Group 1st column, subtotal 2nd column"
onAction="GroupFirstTotalSecond_onAction"/>
<button
id="GroupFirstAverageSecond"
label="Group 1st column, average 2nd column"
onAction="GroupFirstAverageSecond_onAction"/>
<button
id="GroupTwoTotalThird"
label="Group 2 columns, subtotal 3rd column"
onAction="GroupTwoTotalThird_onAction"/>
</menu >
<menu
id="Menu9"
label="MAPS">
<button
id="MapDialog"
label="Location Map from existing worksheet (Cntl+Shft+M)"
onAction="MapDialog_onAction"/>
</menu >
<menu
id="Menu10"
label="MARK">
<button
id="MarkFilteredColumns"
label="Mark Filtered Columns (Cntl+Shft+F)"
onAction="MarkFilteredColumns_onAction"/>
<button
id="MarkInput_String"
label="Mark Input String"
onAction="MarkInput_String_onAction"/>
</menu >
<menu
id="Menu11"
label="PAGE SETUP">
<button
id="PageFormatMaxPortrait"
label="Portrait - Maximum (L,R=0.25"", T,B=0.5"",
H,F=0.3""
"onAction="PageFormatMaxPortrait_onAction"/>
<button
id="PageFormatMaxWidePortrait"
label="Portrait - Max Fit Width (L,R=0.25"", T,B=0.
5"", H,F=0.3""
"onAction="PageFormatMaxWidePortrait_onAction"/>
<button
id="PageFormatMaxLandscape"
label="Landscape - Maximum (L,R=0.25"", T,B=0.5"",
H,F=0.3""
"onAction="PageFormatMaxLandscape_onAction"/>
<button
id="PageFormatMaxWideLandscape"
label="Landscape - Max Fit Width (L,R=0.25"", T,B=0.
5"", H,F=0.3""
"onAction="PageFormatMaxWideLandscape_onAction"/>
</menu >
<menu
id="Menu12"
label="PEDIGREES">
<button
id="MarkNonAlphaPeds"
label="Mark non-alphabetic pedigrees"
onAction="MarkNonAlphaPeds_onAction"/>
<button
id="CorrectSinglePeds"
label="Reverse Parents within selected pedigrees (Cntl+Shft+Z)"
onAction="CorrectSinglePeds_onAction"/>
<button
id="ParsePed"
label="Parse Pedigrees to columns"
onAction="ParsePed_onAction"/>
</menu >
<menu
id="Menu15"
label="PRISM GROUP IMPORT FORMATS">
<button
id="AOIGrpLoad"
label="AOI Group Import"
onAction="AOIGrpLoad_onAction"/>
<button
id="ExptGrpLoad"
label="Experiment Group Import"
onAction="ExptGrpLoad_onAction"/>
<button
id="GEGrpLoad"
label="GE Group Import"
onAction="GEGrpLoad_onAction"/>
<button
id="GEPrsLoad"
label="GE Pair List Import"
onAction="GEPrsLoad_onAction"/>
</menu >
<menu
id="Menu16"
label="PRISM LINKS">
<button
id="OpenLink_COSTARS"
label="WWS"
onAction="OpenLink_COSTARS_onAction"/>
<button
id="OpenLink_Hyperion"
label="Hyperion (Brio) Reports"
onAction="OpenLink_Hyperion_onAction"/>
<button
id="OpenPDAsuite"
label="PDA Data Collection Suite"
onAction="OpenPDAsuite_onAction"/>
<button
id="OpenPhyto"
label="Phytosanitary"
onAction="OpenPhyto_onAction"/>
<button
id="OpenLink_PRISMFldMnl"
label="PRISM Field Manual"
onAction="OpenLink_PRISMFldMnl_onAction"/>
<button
id="OpenLink_PRISMweb"
label="PRISMweb"
onAction="OpenLink_PRISMweb_onAction"/>
<button
id="OpenLink_PRISMQuickRpt"
label="QuickReports"
onAction="OpenLink_PRISMQuickRpt_onAction"/>
<button
id="OpenLink_RegCompliance"
label="RegCompliance"
onAction="OpenLink_RegCompliance_onAction"/>
<button
id="OpenLink_IM"
label="IM --> My Web Applications"
onAction="OpenLink_IM_onAction"/>
<button
id="OpenLink_CGRD"
label="RIM: CGR+D Systems menu"
onAction="OpenLink_CGRD_onAction"/>
<button
id="OpenLink_RIMCrop"
label="RIM Crop Updates"
onAction="OpenLink_RIMCrop_onAction"/>
</menu >
<menu
id="Menu17"
label="PRISM TEMPLATES">
<button
id="OpenADCS"
label="Area Data Collection Spreadsheet (ADCS)"
onAction="OpenADCS_onAction"/>
<button
id="OpenNCBFList"
label="Nursery Experiment Location Add Template"
onAction="OpenNCBFList_onAction"/>
<button
id="OpenDCTList"
label="Yield Test Experiment Location Add Template"
onAction="OpenDCTList_onAction"/>
<button
id="OpenGENameMaint"
label="GE Name Maintenance"
onAction="OpenGENameMaint_onAction"/>
<button
id="OpenSIAdd"
label="Seed Inventory Add"
onAction="OpenSIAdd_onAction"/>
<button
id="OpenSIUpd"
label="Seed Inventory Update"
onAction="OpenSIUpd_onAction"/>
<button
id="OpenSIFind"
label="Seed Inventory Find Criteria"
onAction="OpenSIFind_onAction"/>
<button
id="OpenSIIDFind"
label="Seed Inventory ID Find Criteria"
onAction="OpenSIIDFind_onAction"/>
</menu >
<menu
id="Menu18"
label="PRISM UTILITES">
<button
id="FixEUTraitNames"
label="Abbreviate 'EU TraitName (uom)' >
'TraitName' [col hd]"
onAction="FixEUTraitNames_onAction"/>
<button
id="FixTraitColumns"
label="Format Trait Export Columns/Report - Landscape"
onAction="FixTraitColumns_onAction"/>
<button
id="BuildInString1"
label="IN' String Builder"
onAction="BuildInString1_onAction"/>
<button
id="DeleteBlankDataCols"
label="List/Delete Columns Without Data"
onAction="DeleteBlankDataCols_onAction"/>
<button
id="DelRowsExceptHeader"
label="Remove All Rows Except Row 1"
onAction="DelRowsExceptHeader_onAction"/>
<button
id="RemoveHapHyperlinks"
label="Remove Haploid Hyperlinks"
onAction="RemoveHapHyperlinks_onAction"/>
<button
id="SelectWordArt"
label="Select All WordArt Labels"
onAction="SelectWordArt_onAction"/>
<button
id="UnprotPIsheet"
label="Unprotect PI Spreadsheet"
onAction="UnprotPIsheet_onAction"/>
<button
id="DisplaySerpForm"
label="Range Plot Sort"
onAction="DisplaySerpForm_onAction"/>
</menu >
<menu
id="Menu19"
label="RPExcel2007">
<button
id="OpenHelpDoc"
label="Help Documentation"
onAction="OpenHelpDoc_onAction"/>
<button
id="This_Version"
label="Version"
onAction="This_Version_onAction"/>
</menu >
<separator id="Separator2" />
<button
id="OpenRPTAGS"
label="RPTAGS"
onAction="OpenRPTAGS_onAction"/>
<button
id="Transposer"
label="Transpose Multiple Columns to Rows"
onAction="Transposer_onAction"/>
<button
id="AutoFitAll"
label="Autofit All Columns"
onAction="AutoFitAll_onAction"/>
<button
id="ChartDataLabeler"
label="Chart Data Labeler"
supertip="(Cntl+Shft+L)"
onAction="ChartDataLabeler_onAction"/>
<button
id="OpenGPSCalc"
label="GPS Area Calculator Template"
onAction="OpenGPSCalc_onAction"/>
<button
id="OpenHyper"
label="Hybrid Parent Trait Summary Report"
onAction="OpenHyper_onAction"/>
<separator id="Separator1" />
<menu
id="Menu20"
label="Rows and Columns"
supertip="Join rows or columns, insert blank rows">
<button
id="JoinCols"
label="Join Columns"
onAction="JoinCols_onAction"/>
<button
id="MrgRows"
label="Merge Rows"
onAction="MrgRows_onAction"/>
<button
id="InsertBlanks"
label="Insert Blank Rows"
onAction="InsertBlanks_onAction"/>
</menu >
<menu
id="Menu21"
label="Files">
<button
id="compExcelFiles"
label="Compare Excel Worksheets"
supertip="Compare 2 Excel Worksheets"
onAction="compExcelFiles_onAction"/>
<button
id="mrgcsv"
label="Merge CSV Files"
supertip="Merge all CSV files in a folder"
onAction="mrgcsv_onAction"/>
</menu >
<menu
id="Menu22"
label="Text">
<button
id="delLeading"
label="Remove Leading Characters"
onAction="delLeading_onAction"/>
<button
id="delEnding"
label="Remove Ending Characters"
onAction="delEnding_onAction"/>
<button
id="CharCount"
label="Character Count"
supertip="Counts characters in the selected cells"
onAction="CharCount_onAction"/>
<button
id="butCleantext"
label="Clean Up Text"
supertip="This function will remove a non printable characters from
the selected text"
onAction="butCleantext_onAction"/>
</menu >
</group >
</tab >
</tabs >
</ribbon >
</customUI >