FORMULAS PROTECTION IN EXCEL WORKSHEET

  • Thread starter Thread starter Ra
  • Start date Start date
R

Ra

Please can you let me know if I can protect and hide several formulas in a
worksheet, yet allow the user to still input data and modify data once the
formulas have been protected?

Thank you
 
Tools > Options > Spelling > AutoCorrect > Autocorrect and remove the
correction

If this post helps click Yes
 
Tools > Options > Spelling > AutoCorrect > Autocorrect and remove the
correction

If this post helps click Yes
 
Oops..The below is a wrong post.. To your question.......try the below..

Unprotect the sheet/ Unlock all cells/ Edit > Goto > Special > Formula
Format > Cells... > Protection > Locked..Protect the sheet

If this post helps click Yes
 
Oops..The below is a wrong post.. To your question.......try the below..

Unprotect the sheet/ Unlock all cells/ Edit > Goto > Special > Formula
Format > Cells... > Protection > Locked..Protect the sheet

If this post helps click Yes
 
Jacob

Thank you so much. That is perfect.

Please can I ask you one other question:

I have the following situation:

E5 has todays date
F5 = E5+10
When I enter E6 as say tomoroow's date, F6 does not automatically update not
until 4 rows have been entered. I hope this makes sense. How can I get F6
to automatically update?

Many thanks once again.
 
Jacob

Thank you so much. That is perfect.

Please can I ask you one other question:

I have the following situation:

E5 has todays date
F5 = E5+10
When I enter E6 as say tomoroow's date, F6 does not automatically update not
until 4 rows have been entered. I hope this makes sense. How can I get F6
to automatically update?

Many thanks once again.
 
It should work. Check whether Tools|Calculation is set to Automatic....

If this post helps click Yes
 
It should work. Check whether Tools|Calculation is set to Automatic....

If this post helps click Yes
 
Jacob

It is set to automatic, however, it does not update automatically. Any ideas?
 
Jacob

It is set to automatic, however, it does not update automatically. Any ideas?
 
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

hide, unhide column or row after protect worksheet 4
Can I protect the formulas in a Worksheet but allow data inputting 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
Protecting Formulas in Tables 2
Hiding Formulas and Being Able to Make Changes 2
hide columns on a protected sheet??? 1

Back
Top