VBA Customized Ribbon disappeared

Axelle

New Member
Joined
Apr 16, 2018
Messages
18
Hi,

I have built a customized ribbon in VBA.
This worked well and suddenly it disappeared...
In VBA I added "loss of state" and the physical address of the ribbon, but how can I retrieve it now?

Many thanks for your quick reply.
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Jerry Sullivan

MrExcel MVP
Joined
Mar 18, 2010
Messages
8,787
Hi Axelle,

Did the XML ribbon customization code get removed from the file, or did the custom tab just become not visible?

Was the XML code saved in a specific workbook for use in that workbook or in an add-in for use in multiple workbooks?
 
Last edited:

Axelle

New Member
Joined
Apr 16, 2018
Messages
18
Hi Jerry,

Thanks for your reply.
The custom tab became not visible.
The XML code is saved in this specific workbook.

But I have been able to restore it.
I had changed something in the XML code in Custom UI Editor and apparently this was not accepted by excel.
It was however correctly formed in Custom UI Editor.

I added the physical address of the ribbon, a number that is generated each time.
I did this because I learned this during the course.
Actually, I do not quite understand how this works. Is it possible to send me more information about this?
Thanks in advance.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,366
Messages
5,601,210
Members
414,434
Latest member
Riyen

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top