Quick Links

Protecting specific columns

Home Forums Discussion Protecting specific columns

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
  • #228936

    Is there a way to password lock specific columns in MS Project, similar to how you can protect a MS Excel file? I don’t want to lock the whole document, only some of the columns to ensure they are not altered.

    Also, lock the document so tasks cannot be created or deleted.

    Avatar photoSai Prasad
    • Community Leader
    • Forum Pro

    The answer is No. Some columns are editable and some are calculated, but there is no way to prevent a user from editing a value. A better solution is by using VBA macros – http://bsaiprasad.wordpress.com/2014/11/05/protecting-baseline-fields/. In this blog post, I have demonstrated if the Baseline fields (Baseline Start, Baseline Finish, Baseline Work, Baseline Cost, Baseline Duration) is edited, Project will cancel the operation. You might want to change to your needs.

Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.