Where does this file's custom ribbon tab come from?

[muse43]

Hi,

I am trying to replicate the behavior of an .xlsm file I have. When I open it, I have a custom tab showing. However, if I go into the "customize ribbon" section, it's not there. There also doesn't seem to be any macro running on the workbook open event. Also looked in quick access toolbars and there's nothing... how is this happening??? Any other ways of getting a custom tab to show up (just for that 1 file and on any computer it is opened on)?

Thanks!


PS I'd attach the file but it's my first post and I don't see an option for attachments (??)

I've also posted this on another forum but no reply so trying here. Here's the link to my other post:
https://www.excelforum.com/excel-pr...s-this-files-custom-ribbon-tab-come-from.htmlom.html

 

[Michael M]

You can upload the file to dropbox and then post a link beck here

 

[muse43]

Thanks, here's the link to the file on dropbox:

https://www.dropbox.com/s/mjmr7ng58888lpn/FCDPT V74.xlsm?dl=0

 

[Michael M]

Home Button>>Excel Options>>Customize>>Choose commands from>>FCDPT Tab
Adjust as required.

 

[muse43]

I am using Excel 2010. So I have no home button (I don't think anyway) but I do go to Options>>Customize Ribbon and then I have the drop down for "Choose commands from" but the FCDPT tab is not in there.

I know how to add a custom tab and command. It's just that when I do it, it doesn't transfer to another computer when I move the file. This one does. That's the behavior I'm after... thought this would show me how but I don't see it in there anywhere...

 

[muse43]

I had one possibility that I could not rule out because I'm not familiar and I would have to build it just to find out if it the answer... but what about using Visual Studio to build a custom ribbon. Is it possible it's embedding XML files into the excel file? Here's a link that talks about something like that...

https://docs.microsoft.com/en-us/vi...tab-by-using-the-ribbon-designer?view=vs-2017

I've never worked in VS but would certainly be willing to start if I knew it was the right way to do this...

 

[Michael M]

but I do go to Options>>Customize Ribbon and then I have the drop down for "Choose commands from" but the FCDPT tab is not in there.

Ok look at Excel Options>>Customize>>Choose commands from>>custom Tabs

But it is in the location I mentioned in the file you uploaded to dropbox !

 

[RoryA]

It's done by modifying the CustomUI part of the workbook's XML structure. See Ron's pages here: http://www.rondebruin.nl/win/section2.htm

 

[muse43]

Thanks RoryA, I am going to try that method today to see how it works. Was going to use Visual Studio as suggested in the link I posted above but will now take a look at your link's suggestion of using a custom UI editor.... should be interesting.

Michael M, I'm sorry but I don't have that custom tab in Customize.. maybe custom/embedded ribbon tabs don't show up in Excel 2010? I know if I make my own custom tab then YES, it shows up there. But like I said, it doesn't transfer with the file in that case. This one does. Thanks anyway for your help though.

Will post back with my results....

 

[muse43]

OK final results are in... and the Custom UI editor works great!!! Was exactly what I was looking for. I can edit the ribbon of a particular excel file and the edits stay with the file on any machine. Now I can "Install" that file to have that tab show up on any machine (after installation) on any file (which was the ultimate goal all along).


Thanks again for all your help!! RoryA (aka rorya), you get extra props! lol. Cheers!


PS here's the link to the editor:
openxmldeveloper.org/blog/b/openxmldeveloper/archive/2006/05/26/customuieditor.aspx