Others

How to Restrict Editing of Specific Fields in Microsoft Project

Algirdas Jasaitis Sep 25, 2026 869 views

Question details

The user needs to know how to restrict editing for certain fields while allowing others to remain editable in Microsoft Project.

How to Restrict Editing of Specific Fields in Microsoft Project

Product: Microsoft Project Professional
Device & OS: not provided
Scenario: Managing a project schedule where team members need permission to update actual dates but should be prevented from modifying planned or baseline dates.
Observed behavior: Microsoft Project Desktop does not include a built-in feature to protect individual fields while keeping other specific fields editable through standard permissions.

Before you start

Confirm whether you are using the Microsoft Project Professional Desktop client or a server-based solution like Project Online, as the desktop version has strictly limited field-level permission controls.

Solution 1Recommended

Use Baseline Tracking as a Process Control

Since native field locking is unavailable, saving a project baseline allows you to track and identify any unauthorized changes to planned dates visually.

While you cannot physically lock the planned dates from being clicked and edited, establishing a baseline gives you a permanent snapshot of your original plan. You can then use tracking views to spot discrepancies.

Set the Project Baseline

Navigate to the 'Project' tab on the ribbon, click on 'Set Baseline', choose 'Set Baseline', and click 'OK' to lock in your planned dates.

Update Actual Dates

Allow your team members to update the 'Actual Start' and 'Actual Finish' fields during their standard progress reporting.

Monitor for Discrepancies

Switch your view to the 'Tracking Gantt' (under the 'Task' tab > 'Gantt Chart' dropdown). This will visually display the saved baseline bars against the current scheduled dates, allowing you to instantly see if a planned date was improperly modified.

Use Baseline Tracking as a Process Control

Administrative Control: This method relies on team compliance and project manager review rather than hard system locks.

Solution 2

Implement VBA Macros for Field Protection

Use a custom VBA macro to detect changes to restricted fields and automatically reverse them, simulating field-level protection.

Solution 3

Submit a Feature Request

Report your need for field-level editing restrictions directly to Microsoft to influence future product updates.

Free Microsoft Office alternative

Manage Project Data Securely with WPS Office

If Microsoft Project's lack of field-level protection is slowing you down, consider shifting your project tracking to WPS Spreadsheet. It offers precise cell-level locking, allowing you to secure planned dates while letting your team update actuals effortlessly—all within a free, lightweight suite.

1. Open Your Project Template: Launch WPS Spreadsheet and open your existing project tracking file.
2. Unlock Target Cells: Select the specific cells (like Actual Dates) you want your team to edit, right-click, choose 'Format Cells', go to the 'Protection' tab, and uncheck 'Locked'.
3. Protect the Rest of the Sheet: Navigate to the 'Review' tab, click 'Protect Sheet', and set a password. Now, only the unlocked actual date cells can be modified.

Easily lock specific cells, rows, or columns while keeping others editable for team members.Seamlessly compatible with Microsoft Excel (.xlsx) project tracking templates.Free and lightweight alternative to complex, expensive project management software.Familiar spreadsheet interface ensuring quick adoption without a steep learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Can I use Project Server or Project Online to restrict field editing?

Yes. While the desktop client lacks these controls, Project Server and Project Web App (PWA) offer more granular security configurations, allowing administrators to define specific views and limit what fields team members can update during timesheet or task progress submissions.

How can I share my Microsoft Project file without allowing any edits?

You can save the file in read-only mode. Go to 'File' > 'Save As', click on 'Tools' next to the Save button, select 'General Options', and either check 'Read-only recommended' or set a 'Password to modify'. This forces others to view the file without making changes.

Does saving a baseline automatically lock the baseline fields?

No, saving a baseline populates the baseline fields (like Baseline Start and Baseline Finish), but it does not physically lock them from manual edits in the desktop client. You must rely on visual comparisons using the Tracking Gantt or administrative macro controls to prevent unauthorized changes.

Office Quick Solutions