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&quot;&quot;, T,B=0.5&quot;&quot;,
H,F=0.3&quot;&quot;)"
onAction="PageFormatMaxPortrait_onAction"/
<button
id="PageFormatMaxWidePortrait"
label="Portrait - Max Fit Width (L,R=0.25&quot;&quot;, T,B=0.
5&quot;&quot;, H,F=0.3&quot;&quot;)"
onAction="PageFormatMaxWidePortrait_onAction"/
<button
id="PageFormatMaxLandscape"
label="Landscape - Maximum (L,R=0.25&quot;&quot;, T,B=0.5&quot;&quot;,
H,F=0.3&quot;&quot;)"
onAction="PageFormatMaxLandscape_onAction"/
<button
id="PageFormatMaxWideLandscape"
label="Landscape - Max Fit Width (L,R=0.25&quot;&quot;, T,B=0.
5&quot;&quot;, H,F=0.3&quot;&quot;)"
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 --&gt; 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 &apos;EU TraitName (uom)&apos; &gt;
&apos;TraitName&apos; [col hd]"
onAction="FixEUTraitNames_onAction"/
<button
id="FixTraitColumns"
label="Format Trait Export Columns/Report - Landscape"
onAction="FixTraitColumns_onAction"/
<button
id="BuildInString1"
label="IN&apos; 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

I've never run into a limit. Is everything spelled properly? Is there in
fact a sub with that name?

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



bc_man wrote:
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

Thanks for the response John.

there is a sub in in this workbook with that name. Its bizarre, I can't get
any new sub to be recognized.

Gregg

Jon Peltier wrote:
I've never run into a limit. Is everything spelled properly? Is there in
fact a sub with that name?

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/

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
[quoted text clipped - 4 lines]

The error happens on anything below Character Count

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200911/1