Excel VBA, RibbonX_code

Question

I am currently learning VBA. However, during my tutorials, I ran into many errors and I think the source is a line of code that is always standard in every new and existing Excel file when I open VBA called "RibbonX_code". It does not appear under any add-ins and it is the first time I work with macros and VBA. See the screenshot attached.

Hopefully, someone knows what this code is, what it does, if it truly interferes, and how to delete it.

Tim

Answer 1

That code is, more or less, senseless. Have a look into this file:

https://www.dropbox.com/s/4xn12u5txvywk14/Simpl...

That is all what you need to know to get started with code for the Ribbon.

Andreas.

Answer 2

I got it working and the tutorials are very helpful! Thank you all for your replies.

Answer 3

What I am wondering if this a standard code in Excel VBA? Since I have never used it before I am surprised that there is already a line of code in there. And if it is more or less senseless is it possible to remove it?

Thank you for answering. 

Kind regards,

Tim Frikkee

Answer 4

Hi,

A good ribbon creator: http://www.andypope.info/vba/ribboneditor_2010.htm

Ribbon tutorials: http://rondebruin.nl/win/section2.htm

Answer 5

Reference:

• RibbonX: Customizing the Office Ribbon by Robert Martin, Ken Puls, and Teresa Hennig
• Ribbon and Quick Access Toolbar pages