Hide and Protect Cells/Columns in Resource Sheet

[smck]

I am working in Project 2003 Resource Sheet and have entered Standard Rates
for the resources and would like to hide these rates. (Similar to how you
would use Custom format to hide cell contents in Excel). Can this be done in
Project? I know you can hide a column but anyone can redisplay a hidden
column. Is there a way to hide and protect the rates so that other users
cannot see them?

Thanks for your help.

 

[smck]

Hi Trevor
Thanks for your response; however, deleting would not work in this instance
because the file will be on a shared drive for other users to access and the
information needs to be in the file for calculation/reporting purposes.

smck

 

[Rod Gill]

There are only 2 things you can do:
1) disguise the rate by including overheads and using bands so no one can
differentiate between one resource's pay and another. This is a common
technique.
2) Use VBA to import the rates from a protected Excel spreadsheet in a
secured folder. once cost reports have been printed, delete rates again or
close without saving.

--

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

I am working in Project 2003 Resource Sheet and have entered Standard
Rates
for the resources and would like to hide these rates. (Similar to how you
would use Custom format to hide cell contents in Excel). Can this be done
in
Project? I know you can hide a column but anyone can redisplay a hidden
column. Is there a way to hide and protect the rates so that other users
cannot see them?

Thanks for your help.



__________ Information from ESET Smart Security, version of virus
signature database 4933 (20100310) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4933 (20100310) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Jack Dahlgren MVP]

As Rod replied, you can copy them in when you need them (easy to just copy
the column to and from an excel sheet manually to see how this works)

But, if the information is in the file, then anyone who can read the file
can find the rates. Project does not offer any field level protection.

-Jack Dahlgren