When you use project server local users are something that you want users not to use. All resources should be selected form the Enterprise resource pool.

But how do you stop users from adding new local resources?

I’ve found the option to disable local calendars, but the option to disable local resources  isn’t there.

During one of my recent projects I have developed a VBA script to check for local resources when users update their project plans.

The solution looks at the following of events:

On Open 

Colour code the resource column to:

  • display in red when a local user is used.
  • display in blue when an Enterprise user which wasn’t connected to an AD account
  • default black when all resources assigned to a task are enterprise resources.

On Save

Colour code the resource column to:

  • display in red when a local user is used.
  • display in blue when an Enterprise user which wasn’t connected to an AD account
  • default black when all resources assigned to a task are enterprise resources.
  • Check the project team resources for local resources and warn the user.
  • Cancel the Save when local resources are used.

On Task Change

Colour code the resource column for the task that is updated to:

  • display in red when a local user is used.
  • display in blue when an Enterprise user which wasn’t connected to an AD account
  • default black when all resources assigned to a task are enterprise resources.

Deployment options

When I tested I initially deployed this locally to some projects as I didn’t want to affect all 600+ projects, however after some testing I deployed it to the Enterprise Global.

With the above solution in place it is now impossible to add local resources to a project plan.

Part 2 will show you the code of the solution.

Advertisements