Compile Error: Object library invalid or contains references

[mayurpote]

This is my first Querry to Excel VBA forum, so kindly excuse me if it is not is proper order.
I have developed a excel VBA program for inventory management system & that sheet was working fine for about a year or so.
But from last few days, the sheet is not working & following message is appearing:

"Compile Error: Object library invalid or contains references to object definitions that could not be found."

I am using following references:

1) Visual Basic for Applications
2) Microsoft Excel 15.0 Object Library
3) OLE Automation
4) Microsoft Office 10.0 Object Library
5) Microsoft Forms 2.0 Object Library

My Excel version is 2013, 64 bit Microsoft Windows 10 Operating System.

The same file is getting opened in my collegue PC with same configuration as mentioned above.

Kindly help.

[kersplash]

The same file is getting opened in my collegue PC with same configuration as mentioned above.

I take it that it opens fine on your colleagues computer?

[mayurpote]

Yes it works fine in other PC

[rorya]

If you have Office 2013, the Office reference library should also be version 15.0, not 10.0

[mayurpote]

Sorry that was a type error, the reference file is:
4) Microsoft Office 15.0 Object Library only.
Also sharing some additional inputs:
The Original excel sheet was developed on Excel 2007 but was working fine on Excel 2013 or is working fine on Excel 2013 on other PC except mine.

[rorya]

Do you have activex objects (eg MSForms controls) added to worksheets in that workbook?

[mayurpote]

Yes , I have some userforms & buttons on the Excel for opening the userforms for various application.

[rorya]

Userforms shouldn't be a problem but can you replace the buttons on the sheets with Form buttons rather than ActiveX?

[mayurpote]

I checked the codes & found that the name of the Textbox in Program & actual neam in the Text box Property are not same. But I dont know how it got changed as same is getting opened fine in other PC.
As I cannot change the Textbox Property, I changed the Textbox names in VB Program. After which Compile error has gone but now new error is coming as follow:
" Run Time Error '32809':
Application-defined or object-defined error"
Can Anyone help find the reasons for above issues & solution for it.

[mayurpote]

I am finding that each time when I save the same file, the Textbox names in the Property window are getting changed randomly.

[mayurpote]

Just to clarify: These are ActivX Control Textbox on the Excel sheets & not on the Userform.

[rorya]

It sounds like you are running into the problem that occurs periodically when an Office update is released and one machine has it while another doesn't. It can sometimes be fixed by deleting .exd files from both PCs but the best advice I can give you is to not use activex controls on worksheets if you can possibly avoid it.

[mayurpote]

I am also not able to delete the Textbox. whnever I am trying to do so the Excel stops working & reopens.

[mayurpote]

I have also tried by deleting the .exd file by following path in Run:
%APPDATA%\Microsoft\Forms
But still the problem could not be rectified.

[rorya]

As I said, it doesn't always work - but there could be .exd files in other locations too, so you need to make sure you delete all of them.

Try disabling macros, opening the workbook and then deleting the textboxes.

[mayurpote]

Is there any other solution, if I want to use the Active X Textbox.
Actually I am using the Textbox for searching the required Material in a protected sheet.
Whenever someone enters the text in the Textbox, the sheet unlocks & shows the available material & automatically gets protected again.
I have used this because I was not able to use the filter functionality on a protected sheet.
Is there any other way to use the Filter functionality on a protected sheet?