I have set up a spreadsheet for a co-worker. How do I protect the formulas
so they can't be inadvertently (or intentionally) deleted or written over?
I've tried the instructions "Lock only a few cells on a worksheet" but I can
still change the cells that I want protected.

You need to protect the sheet under toolsprotection

--


Regards,


Peo Sjoblom

"angela" wrote in message
...
I have set up a spreadsheet for a co-worker. How do I protect the formulas
so they can't be inadvertently (or intentionally) deleted or written over?
I've tried the instructions "Lock only a few cells on a worksheet" but I
can
still change the cells that I want protected.

In the FormatCells menu you can lock and unlock cells, then use
toolsprotection and set the options to not allow selection of locked cells.
Hope this helps.

"angela" wrote:

I have set up a spreadsheet for a co-worker. How do I protect the formulas
so they can't be inadvertently (or intentionally) deleted or written over?
I've tried the instructions "Lock only a few cells on a worksheet" but I can
still change the cells that I want protected.

By default, all cells are locked (once you protect the worksheet), so
to lock only a subset of cells, you first need to unlock all the
cells. Press CTRL A twice to select all the cells on the worksheet.
Then go to the Format menu, choose Cells, then Protection. There,
uncheck the Locked option. Click OK. Now, select the cells you want to
lock. Go back to Edit, then Cells, then Protection, and check the
Locked option. Then protect the worksheet from the Tools menu. Cells
that are locked only behave that way when the worksheet is protected.
If the sheet is not protected, locked cells can be modified.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Wed, 12 Nov 2008 07:14:01 -0800, angela
wrote:

I have set up a spreadsheet for a co-worker. How do I protect the formulas
so they can't be inadvertently (or intentionally) deleted or written over?
I've tried the instructions "Lock only a few cells on a worksheet" but I can
still change the cells that I want protected.

Hi,

Tools, Protection, Protect Worksheet, and add a password or not.

This is after you un-lock cells where you want them to work.

Cheers,
Shane

"angela" wrote:

I have set up a spreadsheet for a co-worker. How do I protect the formulas
so they can't be inadvertently (or intentionally) deleted or written over?
I've tried the instructions "Lock only a few cells on a worksheet" but I can
still change the cells that I want protected.