Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Protect cells | Excel Worksheet Functions | |||
Protect only certain Cells? | Excel Discussion (Misc queries) | |||
How do I protect certain cells? | Excel Discussion (Misc queries) | |||
Protect Cells ??? | Excel Discussion (Misc queries) | |||
protect cells in csv | Excel Worksheet Functions |