Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I protect a format but allow editing in cells?
Hi
I want to protect a worksheet's Formats, but allow editing - is this possible? Dion |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I protect a format but allow editing in cells?
Select the cells that should be ok for editing.
Format|Cells|Protection Tab|Uncheck locked Then protect the worksheet tools|protection|protect sheet There are lots of features that are disabled when you protect the worksheet. You may want to check to see it this is really what you want. Custy wrote: Hi I want to protect a worksheet's Formats, but allow editing - is this possible? Dion -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I protect cell numbering format ($) but allow editing? | Excel Discussion (Misc queries) | |||
Creating conditional format to protect cells | Excel Discussion (Misc queries) | |||
editing liked cells | Excel Discussion (Misc queries) | |||
Need Help Editing Cells | New Users to Excel | |||
How can I protect a worksheet yet allow editing in Excel 2000 | Excel Discussion (Misc queries) |