Prtect my formulas

hi,

I am using Office 2010, and I want to protect my spread sheet formulas. it is a simple sheet which just has one row in which each cell sums the rows on top of it.. I would like to give this spread sheet to my staff and let them enter data, but not allow them to edit the formulas.   how do I do this
intelogentAsked:
Who is Participating?
 
Hakan YılmazConnect With a Mentor Technical Office MEP EngineerCommented:
You can protect cells that contain formula and unprotect the cells in which your staff will enter data.

You only need to change "Protected" property of the cells and protect the sheet.

You may look here for more information about protecting cells
0
 
intelogentAuthor Commented:
Thanks works perfectly
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.