Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
protect specific cell but allow edit on other cell
How can I protect specific cells but allow editing on other cells. Once the
cell is edited the file can be saved. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
protect specific cell but allow edit on other cell
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. This is mandatory!! You can set a password to unprotect. These can easily be broken in Excel but will keep your formulas from being accidentally overwritten. Gord Dibben Excel MVP On Tue, 6 Dec 2005 15:44:01 -0800, "chiuinggum" wrote: How can I protect specific cells but allow editing on other cells. Once the cell is edited the file can be saved. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
protect specific cell but allow edit on other cell
but by sheet protection the files could not be saved unless they know the
password. i want only specific cell to be locked preventing alteration but still allow other cells to be edited and file save. "Gord Dibben" wrote: 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. This is mandatory!! You can set a password to unprotect. These can easily be broken in Excel but will keep your formulas from being accidentally overwritten. Gord Dibben Excel MVP On Tue, 6 Dec 2005 15:44:01 -0800, "chiuinggum" wrote: How can I protect specific cells but allow editing on other cells. Once the cell is edited the file can be saved. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
protect specific cell but allow edit on other cell
You can still save a workbook that has sheet protection enabled.
No need for anyone to know a password. Did you try the method I posted or just reject it because you don't understand the process? Gord On Wed, 7 Dec 2005 03:17:02 -0800, "chiuinggum" wrote: but by sheet protection the files could not be saved unless they know the password. i want only specific cell to be locked preventing alteration but still allow other cells to be edited and file save. "Gord Dibben" wrote: 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. This is mandatory!! You can set a password to unprotect. These can easily be broken in Excel but will keep your formulas from being accidentally overwritten. Gord Dibben Excel MVP On Tue, 6 Dec 2005 15:44:01 -0800, "chiuinggum" wrote: How can I protect specific cells but allow editing on other cells. Once the cell is edited the file can be saved. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
protect specific cell but allow edit on other cell
i got it done. thanks. guess i was too rush
"Gord Dibben" wrote: You can still save a workbook that has sheet protection enabled. No need for anyone to know a password. Did you try the method I posted or just reject it because you don't understand the process? Gord On Wed, 7 Dec 2005 03:17:02 -0800, "chiuinggum" wrote: but by sheet protection the files could not be saved unless they know the password. i want only specific cell to be locked preventing alteration but still allow other cells to be edited and file save. "Gord Dibben" wrote: 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. This is mandatory!! You can set a password to unprotect. These can easily be broken in Excel but will keep your formulas from being accidentally overwritten. Gord Dibben Excel MVP On Tue, 6 Dec 2005 15:44:01 -0800, "chiuinggum" wrote: How can I protect specific cells but allow editing on other cells. Once the cell is edited the file can be saved. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
protect specific cell but allow edit on other cell
Happy you got it sorted.
Gord On Thu, 8 Dec 2005 01:37:02 -0800, "chiuinggum" wrote: i got it done. thanks. guess i was too rush "Gord Dibben" wrote: You can still save a workbook that has sheet protection enabled. No need for anyone to know a password. Did you try the method I posted or just reject it because you don't understand the process? Gord On Wed, 7 Dec 2005 03:17:02 -0800, "chiuinggum" wrote: but by sheet protection the files could not be saved unless they know the password. i want only specific cell to be locked preventing alteration but still allow other cells to be edited and file save. "Gord Dibben" wrote: 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. This is mandatory!! You can set a password to unprotect. These can easily be broken in Excel but will keep your formulas from being accidentally overwritten. Gord Dibben Excel MVP On Tue, 6 Dec 2005 15:44:01 -0800, "chiuinggum" wrote: How can I protect specific cells but allow editing on other cells. Once the cell is edited the file can be saved. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink button to a specific cell in excel | Excel Discussion (Misc queries) | |||
Edit cell automatically takes you to cell | Excel Worksheet Functions | |||
how do I highlite text within a cell (specific characters) | Excel Discussion (Misc queries) | |||
How can I edit cell contents with a macro in Excel? | Excel Discussion (Misc queries) | |||
protect a cell | Excel Discussion (Misc queries) |