Protecting Cells from changing or modifying long formulas

  • Thread starter Thread starter Loadmaster
  • Start date Start date
L

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.
 
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.
 
Thank-you it worked.

John C said:
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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Last Modified By in a cell by user 3
protection and changing formulas 3
Protect Only Certain Cells 2
Protecting a Sheet 7
Excel - prevent someone from clicking into certain cells 1
Protecting cell formulas in excel 2007 1
Using a variable spreadsheet reference in a formula 6
Refreshing Pivot Table on a protected spreadsheet tab 1

Back
Top