Click here to Skip to main content
15,881,044 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I would like to change the text above the "press F1 for add-in help" in a custom ribbon. Based on my internet research it is not possible to change "press F1 for add-in help". However, I have seen that people change the bold text above it. i.e. MyDatabase.accdb to "Test".

How is this text changed? I finally found out that the bold text is tied to the 'AppTitle' property of the database. Now, I need figure out how to change this dynamically. Thank you for you help.

Code Example:

XML
<?xml version="1.0"?>

<!-- Created with IDBE RibbonCreator 2010 (Version: 1.1017) -->

<!-- http://www.RibbonCreator2010.com -->

<!-- http://www.RibbonCreator2010.de -->

-<customUI loadImage="LoadImages" onLoad="OnRibbonLoad" xmlns="http://schemas.microsoft.com/office/2009/07/customui">


-<ribbon startFromScratch="false">


-<tabs>


-<tab getVisible="GetVisible" label="Home" id="tab0">


-<group getVisible="GetVisible" label=" " id="grpTEST" tag="RibbonName:=;inMenu:=;CustomTagValue1:=;CustomTagValue2:=;CustomTagValue3:=;CustomPicture:=;CustomPicturePath:=" centerVertically="false" autoScale="false">

<button getVisible="GetVisible" label="Close Quote Search" id="btn0" tag="RibbonName:=;inMenu:=;CustomTagValue1:=;CustomTagValue2:=;CustomTagValue3:=;CustomPicture:=;CustomPicturePath:=" getEnabled="GetEnabled" onAction="OnActionButton" imageMso="BroadcastEnd" supertip=" " screentip="Close Quote Search" size="large"/>

</group>

</tab>

</tabs>

</ribbon>

</customUI>


What I have tried:

I have extensible researched the internet and tried all kind of code snippets without any success.
Posted
Updated 29-Feb-16 13:25pm
v3
Comments
Maciej Los 29-Feb-16 14:50pm    
How did you create this ribbon? Are you developing MS Access COM add-in?
Member 11183408 29-Feb-16 15:05pm    
I used the excellent software IDBE Ribbon Creator to create a XML file for the ribbon.
Maciej Los 29-Feb-16 15:08pm    
And the answer for the second question is...
Member 11183408 29-Feb-16 15:10pm    
I'm not developing MS Com add-in. I'm developing a whole bunch of VBA.
Maciej Los 29-Feb-16 15:49pm    
Improve question by adding xml code.

1 solution

The bold text above the "press F1 for add-in help" in a custom ribbon is set by the database property "AppTitle".

db.Properties("AppTitle").value = "TEST" 'change AppTitle
Application.RefreshTitleBar 'refresh the title bar

Use Macro Autokeys to capture {F1} keystroke and open help
 
Share this answer
 
Comments
Maciej Los 1-Mar-16 8:54am    
5ed!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900