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

If you have xl2002 or later you can.

In earlier versions, there is no support for this.

--
Regards,
Tom Ogilvy


"Lee Schipper" <lee@_reply_to_group_.com> wrote in message
news:[email protected]...
> 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
>
>