I am doing a budget spreadsheet that will always need editing but I don't
want anyone to remove the formulas from cells where the final totals appear.
If I protect the worksheet, I can't edit anything. How can I lock only those
5 cells and still work on the other.

First select the whole sheet using the select all button at the intersection
of column header A and row header 1, then do formatcellsprotection,
deselect hidden, now select the 5 cells you want to protect and do the same
but check locked, finally do toolsprotectionprotect sheet and protect the
sheet. This will leave all other cells open and protect only the 5 cells you
selected


--
Regards,

Peo Sjoblom



"Lock MY Cells" <Lock MY wrote in message
...
I am doing a budget spreadsheet that will always need editing but I don't
want anyone to remove the formulas from cells where the final totals
appear.
If I protect the worksheet, I can't edit anything. How can I lock only
those
5 cells and still work on the other.

Protection is really your only option.
To make things a little easier Click Tools|Customize - Commands Tab -
Format and then drag the lock icont to one of your toolbars. This will make
locking and unlocking cells a lot easier.

Hightlight all of the cells in the entire spreadsheet and click the Lock
icon. Now all of your cells are unlocked. Hit F5 - Special - Formulas -
Ok. Now every cell that contains a formula is selected. Click the lock icon
again to lock these cells. Now protect the sheet.

Everything on the sheet should be open for editing except your formulas
which are the only thing that is locked by the protection...
--
HTH...

Jim Thomlinson


"Lock MY Cells" wrote:

I am doing a budget spreadsheet that will always need editing but I don't
want anyone to remove the formulas from cells where the final totals appear.
If I protect the worksheet, I can't edit anything. How can I lock only those
5 cells and still work on the other.