Hide All Ribbon Tabs except Custom Tab

Hello,

I have the following HTML code in Custom UI editor:

Please Login or Register  to view this content.

In my Excel spreadsheet I have the following code in Sheet1:

Please Login or Register  to view this content.

The above runs as follows:

As the spreadsheet is opened, the Home, review and insert tabs are hidden by setting Visible to false.
However, the formulas tab is still visible???

Can someone point out as to what I am doing wrong ?

Al I want to do is hide all the tabs except one tab which is my custom one.

Crossposted: Modifying ribbon tabs?


Thanks all
Rn

Hello RustyNail,

I have never really done any work with the Ribbon. I remember reading up on it about a year ago and lost interest. Then it was rather complex and unstable coding conundrum and I don't think that has changed much. But, I will look into it for you and post back. In the meantime, perhaps another member knows the answer and will share it.

Hello RustyNail,

Still searching for information related to your problem. So far, nada.

Hello RustyNail,

If you decide to post your question elsewhere to improve your chances for a solution, the forum rules state you should include the other site or sites where you have posted your question.

As a courtesy, I have added the link to Mr Excel to your first post.

The idMso for the formula tab is TabFormulas

if you want to remove all tabs excepty ones you create for the file then use StartFromScratch

Please Login or Register  to view this content.

so this will create a single custom tab, group and button.

Please Login or Register  to view this content.

The idMso is TabPageLayoutExcel

this resource pack should detail on idmso items
https://www.microsoft.com/en-us/down...s.aspx?id=1574

there are equivalent for 2007 and 2013.