LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Custom menus don't appear under custom ribbon tab

Hi,

This is regarding the development of an add-in to create Excel 2007 custom
ribbon ui. I have written the required xml and vba callbacks and every thing
is working fine. The problem is that, the custom menus do not appear under
the custom tab when there is no opened workbook. When I click my custom
ribbon tab, custom menus under that tab do not appear; but when I create a
blank workbook (or open any existing workbook), I can see my custom menus.

However, when I specify "TabHome" to the "insertBeforeMso" attribute in my
custom tab tag, I can see the custom menus; but not before few flickers. Can
anyone help me in this regard? Is it something more to do in the xml
associated to my developed excel add-in? I would be obliged in this regard.
It is becoming frustrating, as I am unable to find much from the resource(s)
so far. Below is my xml code:

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"
onLoad="ribbonLoaded"
<ribbon
<tabs
<tab id="rxTCM" label="TCM" keytip="C"
<group id="rxTCMFile" label="File Menu"
<menu id="rxTCM_File" label="File" keytip="F" size="large" image="FILE"
<button id="rxTCM_File_OpenModel" label="Open Model"
onAction="rxButton_OpenModel" getEnabled="rxButton_OpenModel_getEnabled"
image="imgOpen" keytip="O"/
<button id="rxTCM_File_CloseModel" label="Close Model"
onAction="rxButton_CloseModel" getEnabled="rxButton_CloseModel_getEnabled"
image="imgClose" keytip="C"/
<menuSeparator id="rxTCM_FileMenuSeparator1"/
<button id="rxTCM_File_RecentFile1" onAction="rxButton_RecentFiles"
getLabel="rxTCM_File_RecentFile1_getLabel"
getVisible="rxButton_RecentFiles1_getVisible"/
<button id="rxTCM_File_RecentFile2" onAction="rxButton_RecentFiles"
getLabel="rxTCM_File_RecentFile2_getLabel"
getVisible="rxButton_RecentFiles2_getVisible"/
<button id="rxTCM_File_RecentFile3" onAction="rxButton_RecentFiles"
getLabel="rxTCM_File_RecentFile3_getLabel"
getVisible="rxButton_RecentFiles3_getVisible"/
<button id="rxTCM_File_RecentFile4" onAction="rxButton_RecentFiles"
getLabel="rxTCM_File_RecentFile4_getLabel"
getVisible="rxButton_RecentFiles4_getVisible"/
<menuSeparator id="rxTCM_FileMenuSeparator2"/
<button id="rxTCM_File_Import" label="Import"
onAction="rxButton_Import" getEnabled="rxButton_Import_getEnabled"
image="imgImport" keytip="I"/
<button id="rxTCM_File_Export" label="Export"
onAction="rxButton_Export" getEnabled="rxButton_Export_getEnabled"
image="imgExport" keytip="E"/
<button id="rxTCM_File_Receive" label="Receive"
onAction="rxButton_Receive" getEnabled="rxButton_Receive_getEnabled"
image="imgReceive" keytip="R"/
<button id="rxTCM_File_Extract" label="Extract"
onAction="rxButton_Extract" getEnabled="rxButton_Extract_getEnabled"
image="imgExtract" keytip="X"/
<menuSeparator id="rxTCM_FileMenuSeparator3"/
<button id="rxTCM_File_UpdateOLAPCube" label="Update OLAP Cube"
onAction="rxButton_UpdateOLAPCube"
getEnabled="rxButton_UpdateOLAPCube_getEnabled"/
<button id="rxTCM_File_OLAPReporting" label="OLAP Reporting"
onAction="rxButton_OLAPReporting"
getEnabled="rxButton_OLAPReporting_getEnabled"/
<menuSeparator id="rxTCM_FileMenuSeparator4"/
<button id="rxTCM_File_DataBackup" label="Data Backup"
onAction="rxButton_DataBackup" getEnabled="rxButton_DataBackup_getEnabled"
keytip="B"/
<button id="rxTCM_File_DataRestore" label="Data Restore"
onAction="rxButton_DataRestore" getEnabled="rxButton_DataRestore_getEnabled"
keytip="S"/
</menu
</group

<group id="rxTCMEdit" label="Edit Menu"
<menu id="rxTCM_Edit" label="Edit" keytip="E" size="large" image="EDIT"
<button id="rxTCM_Edit_Enable" label="Enable"
getEnabled="rxButton_Enable_getEnabled" image="imgEdit" keytip="A"/
<menuSeparator id="rxTCM_EditMenuSeparator1"/
<button id="rxTCM_Edit_Lock" label="Lock..." onAction="rxButton_Lock"
getEnabled="rxButton_Lock_getEnabled" image="imgLock" keytip="L"/
<button id="rxTCM_Edit_Unlock" label="Unlock..."
onAction="rxButton_Unlock" getEnabled="rxButton_Unlock_getEnabled"
image="imgUnlock" keytip="U"/
<menuSeparator id="rxTCM_EditMenuSeparator2"/
<button id="rxTCM_Edit_Protect" label="Protect..."
onAction="rxButton_Protect" getEnabled="rxButton_Protect_getEnabled"
image="imgProtect" keytip="P"/
<button id="rxTCM_Edit_EmptySheet" label="Empty Sheet..."
onAction="rxButton_EmptySheet" getEnabled="rxButton_EmptySheet_getEnabled"
keytip="E"/
<button id="rxTCM_Edit_EmptySelection" label="Empty Selection..."
onAction="rxButton_EmptySelection"
getEnabled="rxButton_EmptySelection_getEnabled" keytip="T"/
<menuSeparator id="rxTCM_EditMenuSeparator3"/
<button id="rxTCM_Edit_EmptyRange" label="Empty Range"
onAction="rxButton_EmptyRange" getEnabled="rxButton_EmptyRange_getEnabled"
image="imgEmpty" keytip="M"/
<button id="rxTCM_Edit_SetRange" label="Set Range"
onAction="rxButton_SetRange" getEnabled="rxButton_SetRange_getEnabled"
image="imgSetRange" keytip="S"/
<menuSeparator id="rxTCM_EditMenuSeparator4"/
<button id="rxTCM_Edit_GetPutCell" label="Get/Put Cell..."
onAction="rxButton_GetPutCell" getEnabled="rxButton_GetPutCell_getEnabled"
keytip="G"/
<menuSeparator id="rxTCM_EditMenuSeparator5"/
<button id="rxTCM_Edit_UndoLastTDBAllocation" label="Undo Last TDB
Allocation" onAction="rxButton_UndoLastTDBAllocation"
getEnabled="rxButton_UndoLastTDBAllocation_getEnab led" keytip="A"/
</menu
</group

<group id="rxTCMView" label="View Menu"
<menu id="rxTCM_View" label="View" keytip="V" size="large" image="VIEW"
<button id="rxTCM_View_Navigator" label="Navigator..."
onAction="rxButton_Navigator" getEnabled="rxButton_Navigator_getEnabled"
image="imgNavigator" keytip="N"/
<button id="rxTCM_View_SlicenDice" label="Slice n Dice"
onAction="rxButton_SlicenDice" getEnabled="rxButton_SlicenDice_getEnabled"
image="imgSlice" keytip="S"/
<menuSeparator id="rxTCM_ViewMenuSeparator1"/
<button id="rxTCM_View_RowMembers" label="Row Members..."
onAction="rxButton_RowMembers" getEnabled="rxButton_RowMembers_getEnabled"
image="imgRowMembers" keytip="R"/
<button id="rxTCM_View_ColumnMembers" label="Column Members..."
onAction="rxButton_ColumnMembers"
getEnabled="rxButton_ColumnMembers_getEnabled" image="imgColMembers"
keytip="C"/
<button id="rxTCM_View_OtherMembers" label="Other Members..."
onAction="rxButton_OtherMembers"
getEnabled="rxButton_OtherMembers_getEnabled" image="imgFixedMembers"
keytip="O"/
<menuSeparator id="rxTCM_ViewMenuSeparator2"/
<!--button id="rxTCM_View_FormatNewBrowser" label="Format New
Browser..." onAction="rxButton_FormatNewBrowser" keytip="F"/--
<button id="rxTCM_View_NewBrowser" label="New Browser..."
onAction="rxButton_NewBrowser" getEnabled="rxButton_NewBrowser_getEnabled"
image="imgNewBrowser" keytip="B"/
<button id="rxTCM_View_RefreshBrowser" label="Refresh Browser"
onAction="rxButton_RefreshBrowser"
getEnabled="rxButton_RefreshBrowser_getEnabled" image="imgRefresh"
keytip="E"/
<menuSeparator id="rxTCM_ViewMenuSeparator3"/
<button id="rxTCM_View_ConvertToReport" label="Convert To Report"
onAction="rxButton_ConvertToReport"
getEnabled="rxButton_ConvertToReport_getEnabled" keytip="V"/
<menuSeparator id="rxTCM_ViewMenuSeparator4"/
<button id="rxTCM_View_ShowNextMode" label="Show Next Mode"
onAction="rxButton_ShowNextMode"
getEnabled="rxButton_ShowNextMode_getEnabled" image="imgRules" keytip="M"/
<menuSeparator id="rxTCM_ViewMenuSeparator5"/
<button id="rxTCM_View_Status" label="Status..."
onAction="rxButton_Status" getEnabled="rxButton_Status_getEnabled"
image="imgStatus" keytip="T"/
<menuSeparator id="rxTCM_ViewMenuSeparator6"/
<button id="rxTCM_View_Users" label="Users..."
onAction="rxButton_Users" getEnabled="rxButton_Users_getEnabled"
image="imgUsers" keytip="U"/
</menu
</group

<group id="rxTCMTools" label="Tools Menu"
<menu id="rxTCM_Tools" label="Tools" keytip="T" size="large"
image="TOOLS2"
<button id="rxTCM_Tools_Calculate" label="Calculate..."
onAction="rxButton_Calculate" getEnabled="rxButton_Calculate_getEnabled"
image="imgCalculate" keytip="L"/
<button id="rxTCM_Tools_CalculateandConsolidate" label="Calculate and
Consolidate..." onAction="rxButton_CalculateAndConsoldiate"
getEnabled="rxButton_CalculateAndConsoldiate_getEn abled"
image="imgConsolidate" keytip="U"/
<menuSeparator id="rxTCM_ToolsMenuSeparator1"/
<button id="rxTCM_Tools_RollCAP" label="Roll CAP..."
onAction="rxButton_RollCAP" getEnabled="rxButton_RollCAP_getEnabled"
image="imgRollCAP" keytip="C"/
<button id="rxTCM_Tools_LinkCAP" label="Link CAP..."
onAction="rxButton_LinkCAP" getEnabled="rxButton_LinkCAP_getEnabled"
keytip="K"/
<button id="rxTCM_Tools_RollPeriodBlocks" label="Roll Period
Blocks..." onAction="rxButton_RollPeriodBlocks"
getEnabled="rxButton_RollPeriodBlocks_getEnabled" keytip="R"/
<menuSeparator id="rxTCM_ToolsMenuSeparator2"/
<button id="rxTCM_Tools_CopyVersion" label="Copy Version..."
onAction="rxButton_CopyVersion" getEnabled="rxButton_CopyVersion_getEnabled"
image="imgVersionCopy" keytip="V"/
<menuSeparator id="rxTCM_ToolsMenuSeparator3"/
<button id="rxTCM_Tools_DrillDown" label="Drill Down..."
onAction="rxButton_DrillDown" getEnabled="rxButton_DrillDown_getEnabled"
image="imgDrill" keytip="D"/
<menuSeparator id="rxTCM_ToolsMenuSeparator4"/
<button id="rxTCM_Tools_Validate" label="Validate..."
onAction="rxButton_Validate" getEnabled="rxButton_Validate_getEnabled"
image="imgValidate" keytip="V"/
<menuSeparator id="rxTCM_ToolsMenuSeparator5"/
<button id="rxTCM_Tools_Journal" label="Journal..."
onAction="rxButton_Journal" getVisible="rxButton_Journal_getVisible"
image="imgJournal" keytip="J"/
<button id="rxTCM_Tools_JournalReports" label="Journal Reports..."
onAction="rxButton_JournalReports"
getVisible="rxButton_JournalReports_getVisible" keytip="N"/
<button id="rxTCM_Tools_CellExpansionReports" label="Cell Expansion
Reports..." onAction="rxButton_CellExpansionReports"
getVisible="rxButton_CellExpansionReports_getVisib le" keytip="X"/
<button id="rxTCM_Tools_ICBReports" label="ICB Reports..."
onAction="rxButton_ICBReports" getVisible="rxButton_ICBReports_getVisible"
keytip="E"/
<button id="rxTCM_Tools_AutoBalance" label="Auto Balance..."
onAction="rxButton_AutoBalance" getVisible="rxButton_AutoBalance_getVisible"
keytip="B"/
<button id="rxTCM_Tools_AutoEliminate" label="Auto Eliminate..."
onAction="rxButton_AutoEliminate"
getVisible="rxButton_AutoEliminate_getVisible" keytip="M"/
<menuSeparator id="rxTCM_ToolsMenuSeparator6"/
<button id="rxTCM_Tools_CellText" label="Cell Text..."
onAction="rxButton_CellText" getEnabled="rxButton_CellText_getEnabled"
image="imgCellText" keytip="T"/
<menuSeparator id="rxTCM_ToolsMenuSeparator7"/
<button id="rxTCM_Tools_ProfileSelection" label="Profile Selection..."
onAction="rxButton_ProfileSelection"
getEnabled="rxButton_ProfileSelection_getEnabled" image="imgProfiler"
keytip="S"/
<button id="rxTCM_Tools_NewProfile" label="New Profile..."
onAction="rxButton_NewProfile" getEnabled="rxButton_NewProfile_getEnabled"
keytip="P"/
<button id="rxTCM_Tools_AutoProfile" label="Auto Profile..."
onAction="rxButton_AutoProfile" getEnabled="rxButton_AutoProfile_getEnabled"
keytip="F"/
<button id="rxTCM_Tools_CopyAutoProfiles" label="Copy Auto
Profiles..." onAction="rxButton_CopyAutoProfiles"
getEnabled="rxButton_CopyAutoProfiles_getEnabled" keytip="Y"/
<menuSeparator id="rxTCM_ToolsMenuSeparator8"/
<button id="rxTCM_Tools_TDBSelection" label="TDB Selection..."
onAction="rxButton_TDBSelection"
getEnabled="rxButton_TDBSelection_getEnabled" image="imgTDBNav" keytip="I"/
<button id="rxTCM_Tools_NewTopDownBudget" label="New Top Down
Budget..." onAction="rxButton_NewTopDownBudget"
getEnabled="rxButton_NewTopDownBudget_getEnabled" image="imgTDB" keytip="G"/
<menuSeparator id="rxTCM_ToolsMenuSeparator9"/
<button id="rxTCM_Tools_DataAcquisition" label="Data Acquisition..."
onAction="rxButton_DataAcquisition"
getVisible="rxButton_DataAcquisition_getVisible" keytip="A"/
<menuSeparator id="rxTCM_ToolsMenuSeparator10"/
<menu id="rxTCM_Tools_Options" label="Options..." keytip="O"
<menu id="rxTCM_Tools_BrowserSettings" label="Browser Settings"
keytip="B"
<button id="rxTCM_Tools_ColourFormat" label="Colour Format"
onAction="rxButton_FormatNewBrowser" keytip="C"/
<button id="rxTCM_Tools_CellFormat" label="Cell Format"
onAction="rxButton_Cell_NumberFormat" keytip="E"/
</menu
<button id="rxTCM_Tools_GlobalSettings" label="Global Settings"
onAction="rxButton_Options" keytip="G"/
</menu
</menu
</group

<group id="rxTCMReporting" label="Reporting Menu"
<menu id="rxTCM_Reporting" label="Reporting" keytip="R" size="large"
image="REPORT"
<button id="rxTCM_Reporting_RunReports" label="Run Reports..."
onAction="rxButton_RunReports" getEnabled="rxButton_RunReports_getEnabled"
keytip="U"/
<button id="rxTCM_Reporting_ManageReports" label="Manage Reports..."
onAction="rxButton_ManageReports"
getEnabled="rxButton_ManageReports_getEnabled" keytip="M"/
</menu
</group

<group id="rxTCMHelp" label="Help Menu"
<menu id="rxTCM_Help" label="Help" keytip="H" size="large" image="HELP"
<button id="rxTCM_Help_Contents" label="Contents"
onAction="rxButton_Contents" image="imgHelp"/
<button id="rxTCM_Help_About" label="About" onAction="rxButton_About"/
</menu
</group

</tab
</tabs
</ribbon
</customUI

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Assign custom number format to the ribbon Louis Wilson Excel Discussion (Misc queries) 0 June 24th 09 05:41 PM
Macro Fault on Custom Ribbon Karen[_13_] Excel Programming 5 January 23rd 08 07:32 PM
Office 2007 Custom UI Ribbon - Syntax Check [email protected] Excel Programming 2 May 26th 07 11:38 AM
Custom FaceID's for Custom Menus triaz[_4_] Excel Programming 2 March 1st 06 10:34 AM
Custom faces for custom menus/commandbars Stu Valentine Excel Programming 1 September 17th 04 04:28 AM


All times are GMT +1. The time now is 10:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"