If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Unlocked Cells in Protected Sheet
When i have set a protection in a sheet, i can change the fill color, font,
etc in the unlocked cells? |
#2
|
|||
|
|||
Unlocked Cells in Protected Sheet
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--- "KMA" wrote: When i have set a protection in a sheet, i can change the fill color, font, etc in the unlocked cells? |
#3
|
|||
|
|||
Unlocked Cells in Protected Sheet
Unlocked cell in a protected sheet have no protection at all
-- Regards, Peo Sjoblom "KMA" wrote in message ... When i have set a protection in a sheet, i can change the fill color, font, etc in the unlocked cells? |
#4
|
|||
|
|||
Unlocked Cells in Protected Sheet
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 On Thu, 8 Nov 2007 10:26:02 -0800, KMA wrote: When i have set a protection in a sheet, i can change the fill color, font, etc in the unlocked cells? |
Thread Tools | |
Display Modes | |
|
|