View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
 
Posts: 1,231
Default Formatting in a Protected Spreadsheet

Ang wrote...
I have a password protected spreadsheet that only allows end users
to enter data into specific cells. Is it possible to allow the end
user to format (bold, italics, color) those specific cells, also?
Currently, no formatting is allowed because the spreadsheet's
protected and locked.


There's no way to allow users to format only unlocked cells. Either
they can't format any cells, or they can format all cells.