| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I protect formatting only?
I'm trying to prevent the formatting from changing on a worksheet (Excel
2003) while still allowing users to enter data. Is this possible? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I protect formatting only?
Go to protect sheet and select the options you want to allow users to do.
"ecav" wrote: I'm trying to prevent the formatting from changing on a worksheet (Excel 2003) while still allowing users to enter data. Is this possible? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I protect formatting only?
There's no option for "entering data." How do I allow users to enter data?
"Eric" wrote: Go to protect sheet and select the options you want to allow users to do. "ecav" wrote: I'm trying to prevent the formatting from changing on a worksheet (Excel 2003) while still allowing users to enter data. Is this possible? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I protect formatting only?
The usual default is to allow users to Select both locked and unlocked cells.
By allowing those 2 options, users can select, add, or delete data without being allowed to change the formatting of the sheet. "ecav" wrote: There's no option for "entering data." How do I allow users to enter data? "Eric" wrote: Go to protect sheet and select the options you want to allow users to do. "ecav" wrote: I'm trying to prevent the formatting from changing on a worksheet (Excel 2003) while still allowing users to enter data. Is this possible? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I protect formatting only?
Yes both of those options are selected and I still cannot add data to the
sheet. What am I missing? "Eric" wrote: The usual default is to allow users to Select both locked and unlocked cells. By allowing those 2 options, users can select, add, or delete data without being allowed to change the formatting of the sheet. "ecav" wrote: There's no option for "entering data." How do I allow users to enter data? "Eric" wrote: Go to protect sheet and select the options you want to allow users to do. "ecav" wrote: I'm trying to prevent the formatting from changing on a worksheet (Excel 2003) while still allowing users to enter data. Is this possible? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I protect formatting only?
You are missing the fact that by default all cells are locked when you protect
the sheet. Un protect the sheet. CTRL + a(twice in 2003) to select all cells. FormatCellsProtectionUNcheck "Locked" If you want only some cells unlocked, do not hit CTRL + a.......just select the cells for unlocking and as above uncheck "locked". Now re-protect the sheet with the options you want. Gord Dibben MS Excel MVP On Wed, 10 Jan 2007 14:20:01 -0800, ecav wrote: Yes both of those options are selected and I still cannot add data to the sheet. What am I missing? "Eric" wrote: The usual default is to allow users to Select both locked and unlocked cells. By allowing those 2 options, users can select, add, or delete data without being allowed to change the formatting of the sheet. "ecav" wrote: There's no option for "entering data." How do I allow users to enter data? "Eric" wrote: Go to protect sheet and select the options you want to allow users to do. "ecav" wrote: I'm trying to prevent the formatting from changing on a worksheet (Excel 2003) while still allowing users to enter data. Is this possible? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I protect formatting only?
That's it! Brilliant, thank you.
"Gord Dibben" wrote: You are missing the fact that by default all cells are locked when you protect the sheet. Un protect the sheet. CTRL + a(twice in 2003) to select all cells. FormatCellsProtectionUNcheck "Locked" If you want only some cells unlocked, do not hit CTRL + a.......just select the cells for unlocking and as above uncheck "locked". Now re-protect the sheet with the options you want. Gord Dibben MS Excel MVP On Wed, 10 Jan 2007 14:20:01 -0800, ecav wrote: Yes both of those options are selected and I still cannot add data to the sheet. What am I missing? "Eric" wrote: The usual default is to allow users to Select both locked and unlocked cells. By allowing those 2 options, users can select, add, or delete data without being allowed to change the formatting of the sheet. "ecav" wrote: There's no option for "entering data." How do I allow users to enter data? "Eric" wrote: Go to protect sheet and select the options you want to allow users to do. "ecav" wrote: I'm trying to prevent the formatting from changing on a worksheet (Excel 2003) while still allowing users to enter data. Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autofill default: I want Fill Without Formatting | Excel Discussion (Misc queries) | |||
| Protect formatting & formula | Excel Discussion (Misc queries) | |||
| Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
| Protect conditonal formatting | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
