Excel forms causing Object required, Run-time error '424'

[Sandra2016]

I created a second form for an Excel spreadsheet. When opening the file I received the Object required error. I have tried several things, including creating a third form in which they could select the language or creating buttons on the Excel sheet to select the language (via a module macro) to get around this, nothing is working. The forms are identical except for the language, so one form ends in _EN and the other form in _SP. I have also tried (both to no avail) to unload or hide the other user form when one opens. I have also used Option Explicit for everything. When I use the compile /debug it doesn't find anything. It is only when I open that file that I receive the Object required error. Of course at that point it will not show me where. Any suggestions?

 

[Micron]

You don't get a "debug" option when the error arises? I suspect that the copied form is looking for something that the original form can "see" because that reference was copied over. You could put a break point on the code that is running when the file opens, then step through (F8) until you find the offending part. Or upload a wb copy to a file share and maybe someone will download it to test.

 

[Sandra2016]

No I don't get a debug option when the error arises (probably due to the VBA having password protection). Also if I open up the VBA and run the same setup through there, it runs perfectly. I'll try removing the password and see if I get a debug.

 

[Sandra2016]

Update - found the problem. I unprotected the VBA (and should have thought of that sooner), and found that there was code in 'ThisWorkbook' for when it was opened. It was referencing the old form name. I had completely forgotten there was code there.
Thanks for your help.

 

[Micron]

Exactly the sort of thing I had in mind when I wrote

I suspect that the copied form is looking for something that the original form can "see" because that reference was copied over.

It was seeing a reference to the old form. Glad to see you have a solution.