none
Providing custom context sensitive help for Excel add-in on Ribbon controls RRS feed

  • Question

  • I have created an Excel Add-In (.XLAM file) and a help file (.CHM file) and some custom ribbon controls:

    As you see I already have a Help button that shows my help file if you click it. But when I hover the mouse over a button the Excel UI shows the additional part "Press F1 for add-in help." automatically.

    But when I press the F1 key, Excel did not show my help file.

    Is there a way to show a context sensitive help (same way as it works for Excels buttons in the ribbon)?
    Is there something that I can add to my customUI XML code or a callback for that?

    All similar articles are related to VSTO COM add-ins, like this:
    http://www.codeproject.com/Articles/463282/Custom-Ribbon-Help-for-Office-VSTO-Add-ins

    EDIT: You can download my add-in here:
    https://dl.dropboxusercontent.com/u/35239054/XmlTools.zip

    Andreas.


    Tuesday, December 9, 2014 9:23 AM

Answers

All replies

  • Hi Andreas,

    Based on the description, you want to customize content marked via the figure above.

    As far as I know, we couldn't custom that area at present. You can get more detail about the elements of ribbon control from link below:
    Customizing the 2007 Office Fluent Ribbon for Developers (Part 2 of 3)

    This area is also different between different versions of Excel application. For example, here is screenshot for the Excel 2013 for your reference:

    If you want to Excel suport to customize this area, I suggest that you sbumit the feedback from link below:

    Submit Feedback - Microsoft Office

    Regards & Fei


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Wednesday, December 10, 2014 7:17 AM
    Moderator
  • Based on the description, you want to customize content marked via the figure above.

    Hi Fei, I already noticed that I can't modify that area and that is not what I'm asked.

    I want to know if there is a way to get the F1 key to work.

    E.g.: Within Excel in the Home tab, hover the mouse over the button "Conditional Formatting" and press F1.

    As you see, the Excel help file with the correct context help theme is shown.

    Because Excel automatically displays the additional area for my AddIn I am assuming that the developers have also provided a way how I can show my context-sensitive help.

    Andreas.

    Wednesday, December 10, 2014 11:26 AM
  • Hi Andreas,

    Thanks for the detail explaintation for this issue.

    Since the issue is complex, I'm trying to involve some senior engineers into this issue and it will take some time. Your patience will be greatly appreciated.

    Sorry for any inconvenience and have a nice day!

    Regards & Fei


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Friday, December 12, 2014 5:33 AM
    Moderator
  • Hi Andreas,

    There is not out of the box way to do this . Ribbon xml cannot be used to repurpose keyboard shortcuts

    You may try doing the approach mentioned in the blog below and see if you are able to do it in VBA

    http://blogs.msdn.com/b/vsod/archive/2010/04/08/using-shortcut-keys-to-call-a-function-in-an-office-add-in.aspx

    If you need help in writing code to meet your requirements your question is for advisory support and  falls into the paid support category which requires a more in-depth level of support.  Please visit the below link to see the various paid support options that are available to better meet your needs. http://support.microsoft.com/default.aspx?id=fh;en-us;offerprophone

    If the support engineer determines that the issue is the result of a bug the service request will be a no-charge case and you won't be charged.


    Sangeeth,MSFT

    Tuesday, January 13, 2015 5:46 PM
  • You may try doing the approach mentioned in the blog below and see if you are able to do it in VBA

    http://blogs.msdn.com/b/vsod/archive/2010/04/08/using-shortcut-keys-to-call-a-function-in-an-office-add-in.aspx

    Unfortunately there are no possibilities to realize this with VBA. Thank you for your clarification.

    Andreas.

    Wednesday, January 14, 2015 4:42 PM