ExcelBanter - how do I lock a cell's format but still allow to edit it's value?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do I lock a cell's format but still allow to edit it's value? (https://www.excelbanter.com/excel-discussion-misc-queries/258302-how-do-i-lock-cells-format-but-still-allow-edit-its-value.html)

hitchb

how do I lock a cell's format but still allow to edit it's value?

Dave Peterson

how do I lock a cell's format but still allow to edit it's value?

Unlock the cell, but protect the sheet.

In xl2003 menus:
format|cells|protection tab

And
tools|protection|protect sheet

hitchb wrote:

--

Dave Peterson

All times are GMT +1. The time now is 08:30 PM.