View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lee Schipper Lee Schipper is offline
external usenet poster
 
Posts: 1
Default 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