none
How to Activate build-in Tab when select a chart RRS feed

  • Question

  • I dev a excel addin.

    When use excel, user active some other tab and then select a picture in sheet, excel will not auto active format tab

    How to Activate build-in Tab idMso="TabPictureToolsFormat" by use my code?


    Friday, December 16, 2016 8:39 AM

All replies

  • Hi ChDw,

    you had mentioned that,"user active some other tab and then select a picture in sheet, excel will not auto active format tab".

    let me inform you that when you select a picture. then it will add the "Format" Tab. but you have to click on the Format Tab to use it.

    it will not change the Tab when you select the picture. it will stay on the current Tab which is already active.

    try to use ActiveTabidmso.

    ribbonCollection.Ribbon1.RibbonUI.ActivateTab("MyCustomTab");
    

    or

    this.RibbonUI.ActivateTabMso("TabAddIns");
    

    Reference:

    IRibbonUI.ActivateTabMso Method (Office)

    Regards
    Deepak


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, December 19, 2016 6:29 AM
    Moderator