Formatting on unprotected cells

G

Guest

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
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy data from unlocked cells 3
Can't access cells 2
Can't move between cells. (Not the scroll lock) 1
Protecting Worksheet - Cannot move between cells. 2
How can I have formatting toolbar active for the unprotected(unlocked) cells of the protected worksh 6
Insert pictures 5
Entering photos or pdf into a protected sheet 1
How can I have a protected worksheet and have spell check ability 1

Top