protection of select cells containing formulas

  • Thread starter Thread starter Jack Wildermuth
  • Start date Start date
J

Jack Wildermuth

I guess I am not concidered computer literate as I cannot
understand the instructions on how to protect others from
overwriting cells which contain formulas. I want them to
be able to make entries in some, but want to restrict
entries in others. Everytime I try to follow the help
instructions, I am told the cells are protected and to
make entries, I must "unprotect" the worksheet.

I am well into my "upper sixties" so please be kind with
the answer so I can understand.

Thanks for the help.

Jack Wildermuth
 
Jack,

By default, all cells are locked, so when you protect the worksheet, all
cells are protected. To protect only those cells containing formulas, do
the following:

1) Select all cells by pressing CTRL+A.
2) Go to the Format menu, choose Cells, then the Protection tab. There,
uncheck the Locked check box. Click OK.
3) Press F5 to display the GoTo dialog box. Click the Special button and
choose the Formulas option button. Click OK.
4) Go to the Format menu, choose Cells, then the Protection tab. There,
check the Locked check box. Click OK.
5) Go to the Tools menu, choose Protection and Protect the worksheet.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
I'm 67 so I guess I'm qualified. Copy this macro to a module>select cell
range>execute this macro

Sub protectformulas()
Selection.Cells.Locked = False
For Each c In Selection
If c.HasFormula = True Then c.Locked = True
Next
End Sub
 
Back
Top