Locking Cells

  • Thread starter Thread starter Sue
  • Start date Start date
S

Sue

I am trying to lock cells in a spreadsheet for a budget
that contain formulas but allow changes to the formatting
(wrapping text, bold, italize, etc.) to other cells within
the spreadsheet. Is this possible? If so, how do I set
it up. Thanks!
 
Hi Sue!

In Excel 2002 (XP) you do have the option of allowing formatting of
locked cells. Without selecting that option (during the Tools >
Protect Sheet), you cannot change the format of cells.

I think you'll find that it is all or nothing here. If you allow
formatting of cells, this applies equally to locked and unlocked
cells. If you don't allow formatting of cells (the default) you can't
change the formatting of any of the cells in the sheet even if those
cells are not locked.

For earlier versions of Excel, if you lock the cells for contents,
you're prevented from changing formats whether or not the cells are
locked or unlocked.

But what are your objectives? It might be that VBA can be used to
secure them.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Tuesday 5th August 2003: Burkina Faso
(Independence Day), Croatia (Homeland Thanksgiving Day), Dominican
Republic (Santo Domingo Foundation Day), El Salvador (Transfiguration
San Salvador del Mundo), Peru (Virgen de las Nieves), Tuvalu (National
Children's Day). Observances: Hiroshima Day (23:15 UST 1945)
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top