Protect a column that has a changing value

[FDPetey]

I want to protect a column that has a changing value from a vba script that runs off an entry made on a separate sheet. I tried to lock the cells in the column and protect the sheet but I keep getting the following error -

Run-time error '1004':
The cell or chart you're trying to change is on a protected sheet. To make a change, unprotect the sheet. You might be requested to enter a password.

When I select Debug, the code that gets highlighted is for that protected cell that should be updating.

Any ideas on how to protect the cells so it can be updated with an entry on another sheet but not selected on the reporting sheet and manually changed?

 

[dreid1011]

You would have to add some code to unprotect the sheet before making the change, then protect the sheet again after making the change.