Unlocked Cells in Protected Sheet

K

KMA

When i have set a protection in a sheet, i can change the fill color, font,
etc in the unlocked cells?
 
R

RyGuy

You can choose what is protected and what is not protected. Just follow the
prompts: Tools > Protection > Protect Sheet. Then you decide what you want
users to have access to.

Regards,
Ryan---
 
P

Peo Sjoblom

Unlocked cell in a protected sheet have no protection at all


--


Regards,


Peo Sjoblom
 
G

Gord Dibben

You have a question mark at the end of a declarative.

Which is it?

A question or a statement?

I will assume a question.

If you have allowed users to "select ulocked cells" and "format cells" then you
can format those cells only.


Gord Dibben MS Excel MVP
 

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

Top