| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I format unlocked cells when the work sheet is protected | Excel Discussion (Misc queries) | |||
| Allowing comments in unlocked cells within protected sheet | Excel Discussion (Misc queries) | |||
| paste locked cells and unlocked cells in protected sheet | Excel Worksheet Functions | |||
| protected sheet arrow keys not working on unlocked cells | Excel Discussion (Misc queries) | |||
| move between unlocked cells on protected sheet | Excel Discussion (Misc queries) | |||
Linear Mode
