L
Luck3356
I have written a spreadsheet in Excel 2003. I am attempting to protect
certain cells in the workbook. A requirement of this workbook is to be able
to hide columns. To do this I need to be able to select locked cells. I've
locked the cells that require protecting and when proteting the sheet I've
selected the option to "select locked cells". When I protect the sheet
certain cells do not protect the content (formulas or text) in the cell but
others do. I've tried going back
and unselecting "select lock cells" option and then the cells in question do
protect the content of the cells. Can anyone please explain what is going
on? Shouldn't all cells respond the same given similar formatting?
certain cells in the workbook. A requirement of this workbook is to be able
to hide columns. To do this I need to be able to select locked cells. I've
locked the cells that require protecting and when proteting the sheet I've
selected the option to "select locked cells". When I protect the sheet
certain cells do not protect the content (formulas or text) in the cell but
others do. I've tried going back
and unselecting "select lock cells" option and then the cells in question do
protect the content of the cells. Can anyone please explain what is going
on? Shouldn't all cells respond the same given similar formatting?