February 26th 08, 02:17 AM
posted to microsoft.public.excel.misc
external usenet poster
First recorded activity by ExcelBanter: Feb 2008
Protect (Lock) Cell Formatting ONLY
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
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.
"GraceJean Jones" <GraceJean wrote in
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