Quote Originally Posted by DcD
Sorry. I should clarify.

Basically i created this 'tool' to track team members, with the assistance of yourself. Each team member opens excel and fills in what they have done. All members have there own machines, except some dont have MS Project, with no need of it.

I have ms project, and the reference is in excel. When they open it, they dont have ms project and in there vba references there is a "MISSING : Ms Project 11.0 Object Library". The problem happens with other code in different sheets when the MISSING reference is ticked it doesnt recognise Chr. Untick the missing reference library fixes the problem. They dont need the "Add to Project" Command as it is only for team leaders.

Could you create something like a button or checkbox that when selected will turn on/off that reference? Is this possible?
Dean,

The code as I gave you doesn't need that reference set. If you uncheck it as Dennis said, then distribute it you should get no problems.