Excel 97 Worksheet Protection and cell colour

[andy]

Hi there,

One of our users has setup a worksheet will a small range of cells that are
locked (they have formulas in them), he then protects the sheet.

He then wants to change the colour of some of the other cells, these cells
are not locked, but he cannot change the colour of the cells.

Is there an obvious solution?

Cheers,

Andy

 

[Frank Kabel]

Hi
AFAIK you can't do this in Excel 97 without first removing the
protection

 

[Dave Peterson]

I don't use xl97 anymore, but I could do this in xl2002 (with nothing special
allowed on a protected sheet).

I could copy|paste special|formats over unlocked cells on a protected worksheet.

You could put the colors/formats you like in a nice spot or the user could use
his/her own workbook/worksheet.

(I don't recall if xl97 behaved the same way--but you'll know after a short
test.)

 

[Dave Peterson]

And if you want more control, you could provide a macro that allowed only
certain changes.

You could specify the range and the colors. And not allow anything else.

 

[Gord Dibben]

You can paste special>formats from another sheet to just the unlocked cells.

Not to locked cells.

Gord Dibben Excel MVP