| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
2007 Excel Protecting a cell
I found help on this for 2003, but does not work the same for 2007. I want
to protect a format in a cell but still allow data entry. How can I do this? -- Linda K |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
2007 Excel Protecting a cell
Unlock the cells.
When you protect the sheet do not allow "Format Cells" Gord Dibben MS Excel MVP On Mon, 1 Feb 2010 09:58:02 -0800, LindaAlex wrote: I found help on this for 2003, but does not work the same for 2007. I want to protect a format in a cell but still allow data entry. How can I do this? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
2007 Excel Protecting a cell
That was a easy fix!! Thanks
-- Linda K "Gord Dibben" wrote: Unlock the cells. When you protect the sheet do not allow "Format Cells" Gord Dibben MS Excel MVP On Mon, 1 Feb 2010 09:58:02 -0800, LindaAlex wrote: I found help on this for 2003, but does not work the same for 2007. I want to protect a format in a cell but still allow data entry. How can I do this? . |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
2007 Excel Protecting a cell
That was an easy fix, Thanks.
-- Linda K "Gord Dibben" wrote: Unlock the cells. When you protect the sheet do not allow "Format Cells" Gord Dibben MS Excel MVP On Mon, 1 Feb 2010 09:58:02 -0800, LindaAlex wrote: I found help on this for 2003, but does not work the same for 2007. I want to protect a format in a cell but still allow data entry. How can I do this? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protecting cell formulas in excel 2007 | Excel Discussion (Misc queries) | |||
| Protecting IP in Excel 2007 | Excel Discussion (Misc queries) | |||
| protecting several parts of a worksheet in Excel 2007 | Excel Discussion (Misc queries) | |||
| Protecting an Excel 2007 workbook with a warning before opening | Excel Discussion (Misc queries) | |||
| Excel (Office 2007 B2TR) -- Password Protecting A Sheet -- Character Limit ? | Excel Discussion (Misc queries) | |||
Hybrid Mode
