Excel - Could not load an object...?

[ssmacc]

Hello,
I’ve inherited a Excel worksheet and asked if I can “make it work”. It has some Macro’s that can add lines of predetermined data. However, when I click the “Add” button (runs a particular Macro) I receive a message:

“Could not load an object because it is not available on this machine”

Is this as self-evident as it sounds? As in am I actually missing a file?

If I ignore this and try to continue I see a Visual Basic “Compile Error: Can’t find project or library”?

Can anyone suggest a solution or confirm I am missing a required file? (the person who built the spreadsheet has left the company)

 

[lord filbuster]

You are either missing an activeX control file somewhere, or maybe some of the required libraries aren't selected in the VBA references menu.
I don't mind taking a look if you are able to post the code somewhere.

 

[Grrrrr]

Need to see the code really but a shot in the dark...

In the VBA window if you go to Tools > References you might need to enable something in there, try "Microsoft Scripting Runtime"