question

52608327 avatar image
0 Votes"
52608327 asked RichardMichaels-5985 commented

Excel ribbon & VBA error

Hi,

I 've created a ribbon and when I open the file and click the ribbon tab I get the message:

Visual Basic for Applications
System error &H80070057 (-2147024809).

I removed one group and the error disappeared. The group was named "grpTools". Has someone any help on this error? Google is not very helpful.

Windows 10, Office 2016

More details in the Excel forum:



Wkr,

JP Ronse

P.S. the quality of the forums is deteriorating more and more


[1]: https://answers.microsoft.com/en-us/msoffice/forum/all/excel-ribbon-2010/56adba16-7e12-4fb3-b364-d81a2cadaedb

office-vba-dev
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

From a pure VBA debugging perspective I would suggest that you try to isolate the failing statement. Is there a OnLoad or OnClick event where you could set a breakpoint and then step through each statement? Can you add a message box to the fuctions so that you at least know which function is getting the error?

msgbox "I'm In the ROCPlanning_onLoad code"

0 Votes 0 ·

Hi,

It is related to the getImage callback. It seems that the callback must be in a VB module to avoid the error message.

0 Votes 0 ·

Where had you placed the callback? After moving the callback to the Module, is it working now?

0 Votes 0 ·

0 Answers