View Single Post
  #4   Report Post  
Old February 26th 08, 01:17 AM posted to microsoft.public.excel.misc
Cimjet[_2_] Cimjet[_2_] is offline
external usenet poster
First recorded activity by ExcelBanter: Feb 2008
Posts: 95
Default Protect (Lock) Cell Formatting ONLY

Hi GraceJean
I don't know what version of excel you are using but if you protect sheet,
you can't format,change fonts or resize etc... i am using excel3.
"GraceJean Jones" wrote in
message ...
Thanks for your reply, however, my question was not answered. I want to
able to create cells in a worksheet where users can input numbers, but
change any of the formatting of the cell, such as font style, font size,
color, borders, etc. Thanks again.

"David Biddulph" wrote:

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"
cells in a worksheet, so that users of the worksheet can enter
into these unlocked cells. I have a worksheet where all I want the
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
your assistance.