Protecting Worksheets
Posted by Angie on July 23, 2001 9:55 AM
How do I protect a worksheet from any changes being made to it but still allow users to input data?
Posted by Jan on July 23, 2001 10:14 AM
Hello Angie,
if the majority of your data is NOT to be changed, select the area that may be changed and go to format, cells, protection and DEactivate the "locked"-button.
Then go to extras, protection, and protect the sheet.
If the majority of your data is to be changed, Select all, and then go to format, cells, protection and DEactivate the "locked"-button. Then go back an RE-acivate it for the cells you do not want to be changed. At last go to extras, protection and protect the whole sheet.
Jan
