How to lock a column in Project 2003

P

Prakash

How to lock a column in MS Project 2003?

Example: Duration column should be locked and it shoul dnot be editable. May
be it can be editable through a password, like how we do it in Excel.
 
R

Redneck David

Why are trying to do that?

If some PM is trying to trick you you could try tricking them with a
user-defined field or some other duration column and call it Duration. They
will probably never figure it out.

David
 
P

Prakash

David: What you are saying is a brilliant idea. At the same time, i need to
know whether we can create macro to lock a column? If it is possible, then
can you help me in creating one?

Prakash
 
J

Jack Dahlgren

Which column are you trying to lock? You can put a macro in place to trap
changes using events, but those can be worked around. If someone has write
access to the file, they can not be prevented from making changes to it.

The best solution is to compare against a known good copy of the file and
note any changes.

If you can't trust your project managers, then why did you hire them?

-Jack
 

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

Similar Threads

Format column widths from one table to a separate table on same page 1
How to implement two shifts per day with multiple teams 0
lock columns for different versions of project 0
MS Project. Real progress of the project, % complete 1
Using project as a resource tracker 0
HOW TO INPUT MONTHLY ACCUMULATED SALARY IN MS PROJECT? 0
How to center adjust text above and image in a two column document. 1
Auto populate value from one task to another in MS PROJECT 0

Top