Cannot run the macro 'Solver.xlam!MainEx'

Have you checked that you also have set a reference to "Visual Basic for Applications" in VBA->Tools->Refences?

Alf

Yes, it is checked. Actually, it is not possible to uncheck it, it says "Can't remove control or reference; in use".
But there is another message on startup, which says "Compile error in hidden code", I've attached image of the dialog box. Maybe there are issues with compatibility
Attachment 798593

Actually, the problem is present even with no file opened. The message I get is upon Excel start. I'll try to upload the image of the dialog box again
This particular error message pop up even without any file opened, and when closing the program also. The other error messages like 'Cannot run macro 'Solver.xlam!MainEx';
EUROTOOL.XLAM!Onribbonload; SOLVER.XLAM!GetSolverLabel pop up when I open new blank page.

Actually, the Help button on the dialog box redirects to MS site https://learn.microsoft.com/en-us/of...ulemodule-name
, where it is explained that:

This error commonly occurs when code is incompatible with the version or architecture of this application (for example, code in a document targets 32-bit Microsoft Office applications but it is attempting to run on 64-bit Office).[/I][/I]

But I haven't found any solution to this problem.

2022-09-30.jpg

Oh dear this seems like a though one to solve. Perhaps this link could be of help:

https://answers.microsoft.com/en-us/...f-bd16110396ac
or perhaps this link:
https://www.repairmsexcel.com/blog/f...n-module-excel

Alf

Tried everything described in the links with no success. Eventually I uninstalled completely Office, and reinstalled 32 bit version this time (At first it was 64bit version). It worked, no more error messages.
Thank you for your time and tips.
Hope that this thread is helpful

Glad you managed to solve this problem.

So if I understand your problem properly your excising Office 2010 version was a 32 bit and then you installed Office 2019 64 bit. According to Microsoft this should not be possible https://support.microsoft.com/en-us/...a-ab085b38597f
as you should get a warning telling you that this installation can't be done.

Well it seems we can't always trust Microsoft products to behave the way Microsoft tells us they should.

Alf