| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to protect the formular
I want to share a work book with my co-worker. I had set a formular in column
C. I want to allow that change only column A and B. How to protect the formular in column C. |
|
#2
|
|||
|
|||
|
On Sat, 19 Feb 2005 21:01:03 -0800, joy wrote:
I want to share a work book with my co-worker. I had set a formular in column C. I want to allow that change only column A and B. How to protect the formular in column C. Select all cells on the sheet. Go to Format/Cells/Protection and uncheck "Locked". Then select just column C, again Format/Cells/Protection and check "Locked". Then for this to take effect, it's Tools/Protection/Protect Sheet. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to protect and unprotect 30 worksheets in a file every month . | Excel Worksheet Functions | |||
| Can I protect a spreadsheet from being deleted or moved? | Excel Discussion (Misc queries) | |||
| How to protect Option button in worksheet | Excel Worksheet Functions | |||
| protect a cell | Excel Discussion (Misc queries) | |||
| Password protect cells PivotTable & allow the Pivot Table to refre | Excel Worksheet Functions | |||
Linear Mode
