Excel VBA Custom Ribbon Menu

[lucasabreueng]

Guys, I need some help with a question.

I bought a worksheet which has a custom ribbon menu, where each button performs an action within the worksheet. On one of these buttons I would like to make a change.

When opening the spreadsheet with the custom ui editor, I verified that the button in question is called with the following command: onAction="ToColorAll". However, when opening the VBA Project, I didn't find any sub referring to the control of this ribbon.

 

[RoryA]

Can you not ask whomever you bought the workbook from?

I'm not really sure how we can help you find something we can't see.

 

[lucasabreueng]

Can you not ask whomever you bought the workbook from?

I'm not really sure how we can help you find something we can't see.

I no longer have contact with the seller.

The button structure is as follows:
<button id="Colors"
label="CreateSheet"
size="large"
onAction="ToColorAll"
imageMso="TableExcelSpreadsheetInsert"
screentip="You will assemble the worksheet, color the cells and insert formulas according to hierarchy" />

However, when opening the VBA project, I looked through all the Microsoft Excel Objects, Form Codes and Modules, and I didn't find any references. Maybe there's some way to make the button run a macro that I don't have in VBA that I don't know about.

 

[RoryA]

Have you tried using the Find function in the VB editor to locate the ToColorAll routine?

 

[lucasabreueng]

Yes, I was able to find it using the find command.

But apparently all the commands are inside a library of their own. I can't see the code, because when I try to open the program it closes.

 

[Jon Peltier]

Is this library a separate Excel file? A workbook or an add-in?

 

[lucasabreueng]

I uploaded two images. The first shows the classes and members within the Eng library. Unable to display the definition as the program closes. The second photo shows all the references loaded, there is none missing.

 

[Jon Peltier]

I can't tell what the object browser is referring to. Couldn't you also expand the class modules?

The checked references do not indicate any library which may contain relevant routines, They are standard in Office or Windows.

 

[lucasabreueng]

Initially there was an unchecked library written like this: "MISSING: Eng". However, for some reason, she disappeared from the list of references. I believe it was all pointing to that external library.

As shown in image 1 and 2, I cannot expand further, as the program closes.

 

[Jon Peltier]

The project named Eng is visible in your screenshot, but you blocked out the file name, so the file type is not shown. Is it xlsm or xlam?

Can you view any of the standard code modules in the Eng project?