View Single Post
  #4   Report Post  
Old February 26th 08, 02: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.
Regards
Cimjet
"GraceJean Jones" wrote in
message ...
Thanks for your reply, however, my question was not answered. I want to
be
able to create cells in a worksheet where users can input numbers, but
cannot
change any of the formatting of the cell, such as font style, font size,
font
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"
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
to
be able to do in certain cells is to be able to 'put in or insert'
numbers.
I don't want the users of this worksheet to be able to change the font,
font
color, font size, borders, etc. In other words, I want to create a
worksheet
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.