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.
 

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

Excel Protection 2
corrupted formula in protected worksheet 21
Reference Formula Help 1
summarizing data from various workbooks 3
Indirect 1
Lock workbook 1
Protection 2
Excel: remove cell content but retain formula 3

Back
Top