Object library invalid or contains references to object definitions that could not be found

[always_confused]

Hello,
I have been using the same workbook for over a month now with no issues. Today, upon clicking a button that has always worked fine, I get the error "Object library invalid or contains references to object definitions that could not be found". Can anyone help? I am completely stuck and my workbook is basically useless without the macros. I cannot even run a sub as simple as

Sub test()

MsgBox ("OK")

End Sub

Any help would be greatly appreciated

 

[RoryA]

Is it an activex button by any chance?

 

[always_confused]

Is it an activex button by any chance?

Yes, it is

 

[always_confused]

Is it an activex button by any chance?

I restarted my computer and it's working now....... Very strange, do you know what causes this?

 

[Marc L]

Hi,​

​

usual issue when using an ActiveX button rather than a Form button …​

Also as Excel needs to load all in memory and do not well manage it​

so if your computer does not have much RAM the better is to close a maximum of opened applications before opening Excel …​

 

[always_confused]

Hi,​

​

usual issue when using an ActiveX button rather than a Form button …​

Also as Excel needs to load all in memory and do not well manage it​

so if your computer does not have much RAM the better is to close a maximum of opened application before opening Excel …​

Oh ok, thanks I'll keep that in mind

 

[RoryA]

If you can use a Form button instead, I’d recommend it. They’re much more stable.