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

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
 
T

T. Valko

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

Locking cells but keeping Grouping Function available 1
Making an excel sheet so formulas can not be deleted in the sum to 2
Locking a cell reference in a formula 1
Creating a template that I can reproduce every month by keying ininformation from SAP 8
Protecting Excel Formulas 2
Lock formulas only not data 5
Losing Data From Formulas When Cell Variable Changes 6
Locking by multiple users possible? 0

Top