locking formulas in Excel 2007 so users can't change but can vieworiginal formula?

  • Thread starter Thread starter Verna
  • Start date Start date
V

Verna

Hi All:
Is there a way to lock formulas in Excel 2007 so users can't change
but can view original formula? I can lock/protect a selected group of
cells within a worksheet, but I wan't other users to be able to review
the formulas from which the data is derived. Currently when you lock/
protect a group of cells, you can't see the formula.

Grateful for your expertise!
Verna
 
You can choose to hide the formula but by default it's set to not hide
formulas.

Unprotect the sheet
Select the cell(s) in question
Right click>Format Cells>Protection tab
Uncheck: Hidden
OK

Protect the sheet

The formulas should now be visible.
 

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

Array formula lock-up 1
Protecting Excel Formulas 2
Making an excel sheet so formulas can not be deleted in the sum to 2
Locking a cell reference in a formula 1
Locking cells but keeping Grouping Function available 1
Lock in formulas 2
Lock formulas only not data 5
Creating a template that I can reproduce every month by keying ininformation from SAP 8

Back
Top