Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 118
  • Last Modified:

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
0
intelogent
Asked:
intelogent
1 Solution
 
Hakan YılmazTechnical 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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now