View Single Post
  #2   Report Post  
Old February 25th 08, 10:14 PM posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
First recorded activity by ExcelBanter: Feb 2007
Posts: 8,651
Default Protect (Lock) Cell Formatting ONLY

I'm glad to hear that you know how to protect a sheet and how to lock and
unlock cells. You therefore know how to answer your question.
David Biddulph

"GraceJean Jones" <GraceJean wrote in
message ...
I understand how to protect a worksheet, and I know how to "unlock" certain
cells in a worksheet, so that users of the worksheet can enter information
into these unlocked cells. I have a worksheet where all I want the users
be able to do in certain cells is to be able to 'put in or insert'
I don't want the users of this worksheet to be able to change the font,
color, font size, borders, etc. In other words, I want to create a
where only numbers can be entered into certain cells, but no changes
whatsoever can be made to the cell formatting of these cells. Thanks for
your assistance.