Formatting unlocked cells on protected sheet

[Lee Schipper]

After protecting my sheet, I can enter data into unlocked cells, but I
cannot change the formatting for those same cells. (I need to be able to
adjust the decimal places.)

Is it possible to protect a sheet, but still allow formatting to be changed
on unlocked cells?

Note: I have considered writing VBA code that unprotected the sheet, updated
the cell format, then re-protected the sheet, but this won't work because
there is no way for the VBA code to know the password originally used to
protect the sheet.

TIA!
Lee

 

[Tom Ogilvy]

If you have xl2002 or later you can.

In earlier versions, there is no support for this.