Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formatting on unprotected cells
I have protected a range of cells in a worksheet. Although it is possible to
enter a formula in the unlocked (unprotected) cells on the same sheet, it is not possible to reformat those cells, e.g format them as % or change the number of decimals displayed. Is there any way to allow formatting on the unlocked cells? Thanks |
#2
|
|||
|
|||
Formatting on unprotected cells
This kind of protection was added in xl2002.
The tools|protect|protect sheet has a bunch more options. There are a couple ways around it. You could copy a cell that was formatted the way you want and then edit|paste special|formats If you're developing a tool for others, you could provide a macro that did the work of unprotecting the sheet, changing the format and reprotecting the sheet. MargaretAnnM wrote: I have protected a range of cells in a worksheet. Although it is possible to enter a formula in the unlocked (unprotected) cells on the same sheet, it is not possible to reformat those cells, e.g format them as % or change the number of decimals displayed. Is there any way to allow formatting on the unlocked cells? Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Interrogating cells by cell formatting | Excel Worksheet Functions | |||
How do I link a cells formatting from one worksheet to another? | Excel Worksheet Functions | |||
Excel should allow more options for formatting cells | Excel Worksheet Functions | |||
How to copy "edge" formatting to other cells. | Excel Discussion (Misc queries) | |||
conditional formatting on specific text in cells | Excel Discussion (Misc queries) |