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

muse43

New Member
Joined
Feb 24, 2019
Messages
6
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


 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
19,238
Office Version
  1. 2013
Platform
  1. Windows
You can upload the file to dropbox and then post a link beck here
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
19,238
Office Version
  1. 2013
Platform
  1. Windows
Home Button>>Excel Options>>Customize>>Choose commands from>>FCDPT Tab
Adjust as required.
 

muse43

New Member
Joined
Feb 24, 2019
Messages
6

ADVERTISEMENT

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

New Member
Joined
Feb 24, 2019
Messages
6
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

Well-known Member
Joined
Oct 27, 2005
Messages
19,238
Office Version
  1. 2013
Platform
  1. Windows

ADVERTISEMENT

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 !
 

muse43

New Member
Joined
Feb 24, 2019
Messages
6
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

New Member
Joined
Feb 24, 2019
Messages
6
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
 

Watch MrExcel Video

Forum statistics

Threads
1,108,816
Messages
5,525,058
Members
409,617
Latest member
Lenaf

This Week's Hot Topics

Top