Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking individual cells in an excel spreadsheet
I'm looking to lock specific cells in a spreadsheet so that no one can change
them. It needs to be a workable cell because its part of (or linked to) a formula. I need to be able to change and work with the rest of the spread sheet. I need someones help!!! Thanks for your help in advance! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking individual cells in an excel spreadsheet
Bt default all cells on a protected sheet are locked.
Select all cells using CTRL + a(twice in 2003) FormatCellsProtection. Check unlocked. Select the cells to lock and lock them. ToolsProtectionProtect Worksheet. The cells with formulas will be workable but not editable. Gord Dibben MS Excel MVP On Tue, 23 Sep 2008 15:26:01 -0700, sglassedmkw wrote: I'm looking to lock specific cells in a spreadsheet so that no one can change them. It needs to be a workable cell because its part of (or linked to) a formula. I need to be able to change and work with the rest of the spread sheet. I need someones help!!! Thanks for your help in advance! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking individual cells in an excel spreadsheet
Thank you so much for your response. Unfortunatly, it doesn't seem to be
working for me. Am I maybe missing a step? After I do the initial steps, and then go ToolProtectionProtect Worksheet, which of the boxes need to be checkmarked? Your help is greatly appreciated. sglass "Gord Dibben" wrote: Bt default all cells on a protected sheet are locked. Select all cells using CTRL + a(twice in 2003) FormatCellsProtection. Check unlocked. Select the cells to lock and lock them. ToolsProtectionProtect Worksheet. The cells with formulas will be workable but not editable. Gord Dibben MS Excel MVP On Tue, 23 Sep 2008 15:26:01 -0700, sglassedmkw wrote: I'm looking to lock specific cells in a spreadsheet so that no one can change them. It needs to be a workable cell because its part of (or linked to) a formula. I need to be able to change and work with the rest of the spread sheet. I need someones help!!! Thanks for your help in advance! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking individual cells in an excel spreadsheet
Whichever options you would like users to be allowed can be checked.
I prefer not allowing users to select locked cells but they must be allowed to select unlocked cells. See more in-line below........ On Thu, 25 Sep 2008 08:44:06 -0700, sglassedmkw wrote: Thank you so much for your response. Unfortunatly, it doesn't seem to be working for me. Am I maybe missing a step? After I do the initial steps, and then go ToolProtectionProtect Worksheet, which of the boxes need to be checkmarked? Your help is greatly appreciated. sglass "Gord Dibben" wrote: Bt default all cells on a protected sheet are locked. Select all cells using CTRL + a(twice in 2003) Did you do this? FormatCellsProtection. Check unlocked. Did you do this? Select the cells to lock and lock them Did you do this?. ToolsProtectionProtect Worksheet. Did you do this? Gord The cells with formulas will be workable but not editable. Gord Dibben MS Excel MVP On Tue, 23 Sep 2008 15:26:01 -0700, sglassedmkw wrote: I'm looking to lock specific cells in a spreadsheet so that no one can change them. It needs to be a workable cell because its part of (or linked to) a formula. I need to be able to change and work with the rest of the spread sheet. I need someones help!!! Thanks for your help in advance! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking individual cells in an excel spreadsheet
Haha perfect! Thank you so much!
sglass "Gord Dibben" wrote: Whichever options you would like users to be allowed can be checked. I prefer not allowing users to select locked cells but they must be allowed to select unlocked cells. See more in-line below........ On Thu, 25 Sep 2008 08:44:06 -0700, sglassedmkw wrote: Thank you so much for your response. Unfortunatly, it doesn't seem to be working for me. Am I maybe missing a step? After I do the initial steps, and then go ToolProtectionProtect Worksheet, which of the boxes need to be checkmarked? Your help is greatly appreciated. sglass "Gord Dibben" wrote: Bt default all cells on a protected sheet are locked. Select all cells using CTRL + a(twice in 2003) Did you do this? FormatCellsProtection. Check unlocked. Did you do this? Select the cells to lock and lock them Did you do this?. ToolsProtectionProtect Worksheet. Did you do this? Gord The cells with formulas will be workable but not editable. Gord Dibben MS Excel MVP On Tue, 23 Sep 2008 15:26:01 -0700, sglassedmkw wrote: I'm looking to lock specific cells in a spreadsheet so that no one can change them. It needs to be a workable cell because its part of (or linked to) a formula. I need to be able to change and work with the rest of the spread sheet. I need someones help!!! Thanks for your help in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protecting/locking individual cells? + not displaying #N/A on cel | New Users to Excel | |||
Conditional locking of cells for individual rows | Excel Discussion (Misc queries) | |||
Locking cells in a spreadsheet | Excel Discussion (Misc queries) | |||
I have an excel spreadsheet that keeps locking up on me, I need he | Excel Discussion (Misc queries) | |||
Locking Code In Individual Macros | Excel Discussion (Misc queries) |