Protecting Cells from changing or modifying long formulas
 

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.

Protecting Cells from changing or modifying long formulas
 

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.
--
John C


"Loadmaster" wrote:

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.

Protecting Cells from changing or modifying long formulas
 

Thank-you it worked.

"John C" wrote:

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.
--
John C


"Loadmaster" wrote:

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.