How can I Hide rates in Resource Worksheet

D

DNGRE

I work in an environment in which the hourly rates of project team members is
considered sensitive information. Is there any way that I can conceal this
information and still share the Project file with team members? Can I
password protect the rates or make the resource sheet invisible to everyone
except me? Thanks.
 
A

Andrew Lavinsky

Nope. Typically you could:

1) Invest in Project Server, and control the views to which they have access
using their browser.
2) PDF specific views of the project schedule for their consumption (or use
the Copy Project to Office Wizard)
3) Delete the rates manually or using a macro before distribution.

Note that most folks frown on #3 as it's generally considered a bad (or at
least undesireable) practice to distribute an MPP file for consumption purposes.
#2 would probably be preferred.

- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm
 
S

Steve House

Version doesn't matter, you can't selectively hide portions of the file. If
someone has access to the file, they have access to all of it. If they're
not high enough in the organization heirarchy to have access to salary/cost
data, they're not high enough to access the original project file itself
either. Give them what they need to know as reports and pdf screen shots.
 
R

Rod Gill

A common method is to only use standard band rates for each resource that
include overheads and other admin costs. That way direct pay rates are well
hidden.

otherwise Project Server Views or a macro to temporarily read rates from a
spreadsheet or database, print reports then delete rates (can be done
manually each time) are the only ways to go.

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com




DNGRE said:
I work in an environment in which the hourly rates of project team members
is
considered sensitive information. Is there any way that I can conceal
this
information and still share the Project file with team members? Can I
password protect the rates or make the resource sheet invisible to
everyone
except me? Thanks.

__________ Information from ESET Smart Security, version of virus
signature database 5145 (20100525) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 5145 (20100525) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top