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

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