Protecting a Cell

  • Thread starter Thread starter Mark1
  • Start date Start date
M

Mark1

Is there a way to protect a cell's formula without
protecting the worksheet. I want people to be able to key
in data, but not change my formulas.
 
Hi Mark
1. Highlight all cells for which people are allowed to perform entries
2. Goto 'Format - Cells - Protection" and uncheck/disable the
protection for these cells
3. Protect the worksheet

HTH
Frank
 
You must log in or register to reply here.

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

Hiding Formulas and Being Able to Make Changes 2
corrupted formula in protected worksheet 21
protecting formulas without protecting sheet so grouping still wor 1
Protected Worksheets with info that needs to be deleted. 5
Protect Only Certain Cells 2
Protecting a Sheet 7
Protecting select cells 2
hide columns on a protected sheet??? 1

Back
Top