Runtime '424' and Forms

[KyBubba]

I recently created a sheet that uses an ActiveX button on a sheet to call a userform. The code ran flawlessly on 9 of the 10 machines. The one machine that it would not run kept throwing a runtime 424 error object required. Does any one know if I need to change my code or is it a setting on that machine that needs to be changed?

 

[Hamburgler]

Just some guesses: Are the security settings on the 10th machine the same as the others? Is it the same version of Excel? Are the necessary references enabled in the VBE>TOOLS>REFERENCE dialog? I get some pretty random Excel VBA errors when sharing Excel XLSM workbooks with office coworkers. I think that it some something to do with the network security. I would be interested to hear what this is if you figure it out.

 

[Norie]

Is there is any code that gets called when the userform is opened?

For example any code in it's Initialize or Activate events?