If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Cell lock help
Is there a way to lock a specific set of cells and not the whole work sheet?
I have several cells that have formulas in them that I do not want changed, but other cells I need the user to add their daily info. Any help is appreciated. Steve |
#2
|
|||
|
|||
Select the whole sheet, do formatcellsprotection, uncheck locked,
select the formulas in question (hold down ctrl while selecting them or press F5 and click special, select formulas and press enter). Do formatcellsprotection and check locked. Protect the sheet. Regards, Peo Sjoblom "S.C" wrote: Is there a way to lock a specific set of cells and not the whole work sheet? I have several cells that have formulas in them that I do not want changed, but other cells I need the user to add their daily info. Any help is appreciated. Steve |
#3
|
|||
|
|||
Steve
By default all cells are locked when the sheet is protected. Hit CRTL + A(twice if xl2003) then FormatCellsProtection. Uncheck "locked" and OK. Select the cells you wish to lock and FormatCellsProtection. Check "locked" and OK. Now ToolsProtectionProtect Sheet. Gord Dibben Excel MVP On Tue, 11 Jan 2005 16:57:28 -0500, "S.C" wrote: Is there a way to lock a specific set of cells and not the whole work sheet? I have several cells that have formulas in them that I do not want changed, but other cells I need the user to add their daily info. Any help is appreciated. Steve |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I lock an image into a cell and be able to sort? | Ellen | General Discussion | 3 | October 19th, 2004 08:44 PM |
Newbie - Insert picture and lock to cell | Chris Harden | Charts and Charting | 2 | January 16th, 2004 04:11 PM |
using cell contents in pathname | Don Guillett | Worksheet Functions | 7 | January 2nd, 2004 02:11 PM |
How to lock one cell in formula? | Worksheet Functions | 2 | December 26th, 2003 01:22 PM | |
Link or paste cells based on Date in cell | Ayanna | Worksheet Functions | 0 | December 16th, 2003 06:10 PM |