Protecting Cells from changing or modifying long formulas

[Loadmaster]

How do I protect certain cells from being changed by other users because i
have a long formula within the cell? The rest of the cell in the spreadsheet
they can modify, except those particular cells.

 

[John C]

Choose the cells that can be modified by the user, go to Menu Format|Cells,
the protection tab, and uncheck the 'Locked' box. Then go to menu
Tools|Protection, and choose your method of protection, with or without
password. Whatever cells are not locked, people can modify, whatever is
locked, people cannot modify.

 

[Loadmaster]

Thank-you it worked.

Choose the cells that can be modified by the user, go to Menu Format|Cells,
the protection tab, and uncheck the 'Locked' box. Then go to menu
Tools|Protection, and choose your method of protection, with or without
password. Whatever cells are not locked, people can modify, whatever is
locked, people cannot modify.