Locking down a sheet but allowing cell updates

[JonnyStout]

Hi,

Is there a way of locking a sheet so the data cannot be manually changed, but can be updated from another source?

I have 2 sheets (A and B).

Sheet A is where the person inputs what they want.
Sheet B is all these formulas checking if the information in A is correct and notifying if something is missing.

I don't want the user to be able to type anything into sheet B, I just want the cells to be updated from sheet A.

For example if they don't enter a date in a certain cell on A then B shows a red NO DATE ENTERED.
Then when the date is entered B just shows this.

It's a form they need to fill out and rather than combing through everything I want sheet B to show what's missing and then update every time something is entered correctly.

I have it all worked out, just need to lock it down so the user cannot change anything on sheet B

 

[KB_Miner]

Select Sheet2, then go up to the Review tab at the top and hit Protect Sheet. Sheet1 will stay unlocked, so data can be manipulated. Any formulas, conditional formatting, etc on Sheet2 should still update.

 

[JonnyStout]

Hi,

I just tried that and it didn't work.
I protected sheet B but when I put anything into sheet A I get an error saying "the cell or chart you are trying to change is protected and is therefore read-only"

 

[KB_Miner]

On Sheet A, if you go up to the Review tab, does it show Protect Sheet or Unprotect Sheet? Just want to make sure that Sheet A is unprotected as just updating fields on Sheet A shouldn't give you that error. Are the formulas already on Sheet B, or are they being put there by a macro?