|
| 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
November 8th, 2007, 06:26 PM
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
November 8th, 2007, 06:42 PM
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
November 8th, 2007, 06:43 PM
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
November 8th, 2007, 07:08 PM
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?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
