Hide Add-in in Custom Ribbon Option

Add-in Express™ Support Service
That's what is more important than anything else

Hide Add-in in Custom Ribbon Option
 
Albert Siagian




Posts: 83
Joined: 2012-05-25
Hello,

In Excel Options menu (2010-2016), customize ribbon, I can see my add-in is listed there to customize. Can I hide it so it doesn't appear in there ?

Regards
Albert
Posted 16 May, 2017 20:00:23 Top
Andrei Smolin


Add-in Express team


Posts: 14106
Joined: 2006-05-11
Hello Albert,

Set ADXRibbonTab.Shared = true on your tab and no one (including you) will not be able to customize it. To use this setting, you may also need to set a string to the ADXAddinModule.Namespace property. Find more details about these properties in section Sharing Ribbon controls across multiple add-ins at https://www.add-in-express.com/docs/net-ribbon-components.php#sharing-ribbon-controls.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 17 May, 2017 05:02:59 Top
Albert Siagian




Posts: 83
Joined: 2012-05-25
Hello Andrei,

Thanks so much. It works.

Regards
Albert
Posted 17 May, 2017 05:28:54 Top
Andrei Smolin


Add-in Express team


Posts: 14106
Joined: 2006-05-11
Welcome!

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 17 May, 2017 05:32:32 Top
Albert Siagian




Posts: 83
Joined: 2012-05-25
Hello Andrei,

Sorry to reopen this case again.

In some processes, I use ribbontab.activate. Example in XL 2013 new workbook event, I use ribbontab.activate, so that the new workbook automatically goes to my addin tab. This works fine with ADXRibbonTab.Shared = false. However if I Set ADXRibbonTab.Shared = true, it no longer works. It always go to Home tab. Is this correct or is there anyway to activate the tab with shared = true ?

Regards
Albert
Posted 30 May, 2017 07:08:01 Top
Andrei Smolin


Add-in Express team


Posts: 14106
Joined: 2006-05-11
Hello Albert,

You cannot modify properties of a tab (or any container control) having Shared=true at the run time.

You can try to use Windows Automation or Active Accessibility to activate that tab. Not sure if this works.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 30 May, 2017 09:28:46 Top
Albert Siagian




Posts: 83
Joined: 2012-05-25
Thanks for the info Andrei.
Posted 30 May, 2017 20:31:27 Top
Andrei Smolin


Add-in Express team


Posts: 14106
Joined: 2006-05-11
You are welcome.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 31 May, 2017 03:29:52 Top