General discussion

Locked

Protecting Excel Formulas

By jwalker7 ·
I am in the process of creating a time sheet in Excel for employees at my job, and am wondering if there is any way to protect Excel Formulas, but at the same time allowing the user to insert a row on the same line a protected formula is on?

Any help is appreciated...

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Protecting Excel Formulas

by DKlippert In reply to Protecting Excel Formulas

Choose the cells you do NOT want to protect, then go to Format>Cells>Protection and remove the check mark from locked. Now when you use Tools>Protection>Protect sheet the cells that still have a check mark will be locked.

Collapse -

Protecting Excel Formulas

by jwalker7 In reply to Protecting Excel Formulas

Poster rated this answer

Collapse -

Protecting Excel Formulas

by jwalker7 In reply to Protecting Excel Formulas

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Forums