How do I protect a single cell on a spreadsheet? I do know how to protect the complete spreadsheet.
B Bernie Nov 4, 2004 #1 How do I protect a single cell on a spreadsheet? I do know how to protect the complete spreadsheet.
H Harald Staff Nov 4, 2004 #2 Hi You can't. Two workarounds: Either unlock all cells but that one, and then protect the sheet (there are things you aren't allowed to do with protected sheets), or have a macro running that ensures that the cell's content/format stays unchanged. HTH. Best wishes Harald
Hi You can't. Two workarounds: Either unlock all cells but that one, and then protect the sheet (there are things you aren't allowed to do with protected sheets), or have a macro running that ensures that the cell's content/format stays unchanged. HTH. Best wishes Harald
