FORMULAS PROTECTION IN EXCEL WORKSHEET

[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

 

[Jacob Skaria]

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

If this post helps click Yes

 

[Jacob Skaria]

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

If this post helps click Yes

 

[Jacob Skaria]

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 Skaria]

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

 

[Ra]

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.

 

[Ra]

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 Skaria]

It should work. Check whether Tools|Calculation is set to Automatic....

If this post helps click Yes

 

[Jacob Skaria]

It should work. Check whether Tools|Calculation is set to Automatic....

If this post helps click Yes

 

[Ra]

Jacob

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

 

[Ra]

Jacob

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

 

[Jacob Skaria]

Check for the cell formats....OR..Try this in a fresh sheet...

 

[Jacob Skaria]

Check for the cell formats....OR..Try this in a fresh sheet...