0

Protecting specific columns

Home › Forums › Discussion Forum › Protecting specific columns

Viewing 1 reply thread
  • Author
    Posts
    • 11/04/2014 at 11:59 am #228936
      Angela
      Guest

      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.

    • 11/04/2014 at 11:09 pm #229614
      Sai Prasad
      Participant

      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 – https://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.

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.