Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I don't want to protect the whole sheet, and then set up exclusion ranges. I
want to protect the C column only. Is there a way to do that? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Bruce
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 Fri, 16 Jun 2006 09:03:02 -0700, Bruce wrote: I don't want to protect the whole sheet, and then set up exclusion ranges. I want to protect the C column only. Is there a way to do that? Gord Dibben MS Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Match function...random search? | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Look for change next blank cell in Range | Excel Worksheet Functions | |||
Function to determine if any cell in a range is contained in a given cell | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |