Excel 2000 cell format of unlocked cells in aprotected sheet

J

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
 
B

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
Click to expand...
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.
 
Top