Excel 2000 cell format of unlocked cells in aprotected sheet

[JG484]

Excel 2000
I have created an excel spreadsheet with dropdown lists, formulae etc. and I
have locked these particular cells and unlocked the rest. When I protect the
sheet it allows me to type in the unlocked cells, but will not allow me to
format the cells, eg font, colour etc.
Does anyone know how I could format the unlocked cells.

I was able to do this using excel 2003 and thought I could save it and allow
the excel 2000 users to work with it, but to no avail.

Thanks
JG

 

[Bob Greenblatt]

Excel 2000
I have created an excel spreadsheet with dropdown lists, formulae etc. and I
have locked these particular cells and unlocked the rest. When I protect the
sheet it allows me to type in the unlocked cells, but will not allow me to
format the cells, eg font, colour etc.
Does anyone know how I could format the unlocked cells.

I was able to do this using excel 2003 and thought I could save it and allow
the excel 2000 users to work with it, but to no avail.

Thanks
JG

Unfortunately, if worksheet is protected, and content is checked, the cell's
format can not be changed. The only way to do this is via a macro that will
unprotect the sheet, make the required formatting changes, and then
reprotect the sheet.