Formatting unlocked cells on protected sheet
 

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

Formatting unlocked cells on protected sheet
 

If you have xl2002 or later you can.

In earlier versions, there is no support for this.

--
Regards,
Tom Ogilvy


"Lee Schipper" wrote in message
...
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