Hi,
Is it possibe to disable entry with text or nummers in a range of cells,
but allow changing cell color in an unlocked cell ?
Can it be done with a macro?
Hans

On Jul 15, 3:20 pm, "H@C0" <n...@fish.net> wrote:
> Hi,
> Is it possibe to disable entry with text or nummers in a range of cells,
> but allow changing cell color in an unlocked cell ?
> Can it be done with a macro?
> Hans

hi,

go to tools- protection and protect your sheet.
in protection dialogue box check the FORMAT CELLS option.

bye,
naweed

Hi naweed,
Thanks for your response.
In Protect sheet I have all unchecked except FORMAT CELLS and SELECT
UNLOCKED CELLS.
I want SELECT UNLOCKED CELLS checked to be abble to change range color, but
then you also can change the cell entry.
Regards, Hans

This is not my experience.
I use Format | Format Cells opened Protection tab and unlocked all cells,
then locked F1:F10
Then in Tools | Protection, I protected the sheet with these boxed checked:
Protect Worksheet...., Select locked, Select unlocked, and Format Cells
Now I cannot change any value in F1:F10 but I can format including changing
colour.
I am using XL2003 for this experiment
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"H@C0" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi naweed,
> Thanks for your response.
> In Protect sheet I have all unchecked except FORMAT CELLS and SELECT
> UNLOCKED CELLS.
> I want SELECT UNLOCKED CELLS checked to be abble to change range color,
> but
> then you also can change the cell entry.
> Regards, Hans
>

Thanks for the explanation, it works in my xl2002
By the way: interesting web site.
Regards


On Sun, 15 Jul 2007 10:09:00 -0300, "Bernard Liengme"
<(E-Mail Removed)> wrote:

>This is not my experience.
>I use Format | Format Cells opened Protection tab and unlocked all cells,
>then locked F1:F10
>Then in Tools | Protection, I protected the sheet with these boxed checked:
>Protect Worksheet...., Select locked, Select unlocked, and Format Cells
>Now I cannot change any value in F1:F10 but I can format including changing
>colour.
>I am using XL2003 for this experiment
>best wishes