In Microsoft Project you will need to turn on the appropriate Object library that is causing the error. This can be done by going to Macro, Visual Basic editior, then within Visual Basic select tools references and enabling the appropriate application that is part of the macro that you are running. Since you don’t mention what the macro is doing, this should get you close. I would also make sure that SP2 was installed on your colleague’s machine.
