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.
Pieter Veenstra
Is your business still running on paper trails, sprawling Excel files, or ageing Access databases? There's a better way — and I can show you exactly what it looks like. I'm the Technical Director of Vantage 365, a Microsoft solutions consultancy working with clients across the UK, the Netherlands, and worldwide. For over 30 years I've been turning messy, manual business processes into clean, automated systems that save time, reduce errors, and give teams the visibility they need to make better decisions. SharePains is not just any blog run by a Microsoft MVP. Have you ever used Try-Catch in Power Automate? The original post about Try-Catch in Power Automate can still be found on this site, https://sharepains.com/2018/02/07/try-catch-finally-in-power-automate-flow/ Or have you ever used the Pieter’s method to avoid variables and speed up your flows? https://sharepains.com/2020/03/11/pieters-method-for-advanced-in-flows/ You can contact me using contact@sharepains.com