MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by kevin on July 21, 2001 8:34 AM

Is there a way to protect just a range of cells.
I can do the whole sheet but not the range of cells
I have excel 97

Posted by Barrett (South London) on July 21, 2001 12:39 PM

Do as you are doing but select only the cells you want not all, lock then can password all sorts, sounds like your CTRL+A (Select all) just what you want..

WARNING if you change it i think E97 will loose the original so i set ALL every time.. i cheat in A1 i add a commet ref all locked / protected cells jsut so i can add and BINGO

Posted by Ian on July 22, 2001 2:00 PM

Yes! the easiest way is to work backwards (so to speak), unless of course you want to protect more cells than not.

first ctrl+a (select all)

goto format_cells protection and uncheck the locked box.

then you can highlight all the cells you want to protect and do the same but this time check the locked box.

now if you protect the sheet only the cells you locked will be protected.