Help on locking cells

[B]

I created a form-like version in Excel where a certain number of cells allow
input similar to the sample template that came with Excel called
"ExpenseStatement", the TOTAL field is locked and a formula is associated
with it.

I wanted to replicate the feature of the TOTAL field on my form, by going
through each cell and assigning which ones are locked and unlocked and
protecting the sheet. But whenever I click on the LOCKED field it kept
giving me a message of "The cell or chart you are trying to change is
protected and therefore read-only".

Is there another setup I need to change?

Pls help.

TIA!
Bob

 

[Guest]

Sounds like the sheet or workbook is already PROTECTED. Check
Tools|Protection and if 'Unprotect Sheet' or 'Unprotect Workbook' appears on
the drop down list, click on that to unprotect the sheet and workbook. Then,
hold down the control key and click on every cell you want to unlock (they
are all locked by default). Use Format|Cells|Protection and remove the
checkmark to unlock those cells. When you have everything the way you want,
go back and Tools|Protection|Protect Sheet.