Protecting formula in workbook

  • Thread starter Thread starter Theresa
  • Start date Start date
T

Theresa

I need to be able to protect the formula in a workbook,
however, I need for the user to be able to input their
data in the areas outside the formulas I have created for
calculation. The workbook is already created with the
formula to calculate data I do not wnat them to have
access to change the formulas or other data created on
the wookbook how can I do this?
 
Select the cell(s) you want to protect and select:

FORMAT/CELLS/PROTECTION and select LOCKED.

Then goto the cells you wnat the user to be able to edit
and do the same only unselect LOCKED.

Then do this:

TOOLS/PROTECTION/PROTECT SHEET. Use password if you want
but you better not forget it. this last step turns on
protection. The first step does nothing until this step
is completed.
 
Should be easy:
Select the cells that the users CAN modify. then go to
menu=Format/Cells, click on Protection tab, uncheck
Locked, click ok. then go to Tools\Protection\Protect
sheet (add password if you dare). click ok.
By default, all cells, except the ones you unlocked
are locked.
 
Back
Top