Customize Ribbon details to excel cell in VB

[mehidy1437]

Hi, I have a couple of customizing ribbons. I want to get all the customize ribbon & command details in excel cells as below.
How can I get this?
My all macros are saved in multiple modules in personal.xlsb file.

 

[bobsan42]

Extract the customui.xml
Try to run it throu power query to get all elements in a table format.
This should also give you the callbacks names.
Then you have open the xlsb in VBE and get from the callbacks the subs/functions which are called by each button.
After you have the subs names there maybe some code out there which goes into the VBA project and gets the names of the modules which contain the subs.
Maybe it is faster to do all this manually Normally it should be done during development stage.

 

[mehidy1437]

Thanks for your response, I'm not quiet familiar with power query.

If there would be VBA solutions for the entire out put, that would be better. In any case thanks for your information.

 

[bobsan42]

Well, I don't think you will be able to find an universal solution. Thera are different ways a custom ribbon can be designed even if you leave dynamic menus aside. Not to mention callbacks and the code behind them.
So you will need to provide some relevant sample of your ribbon xml and your code.
It's too complicated to completely automate such a process.