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. I therefore need to be able to select locked cells. I've
locked the cells that require protecting and 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? This is a basic worksheet with no Visual basic programming. 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. I therefore need to be able to select locked cells. I've
locked the cells that require protecting and 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? This is a basic worksheet with no Visual basic programming. Shouldn't
all cells respond the same given similar formatting?