FORMULAS PROTECTION IN EXCEL WORKSHEET
It should work. Check whether Tools|Calculation is set to Automatic....
If this post helps click Yes
---------------
Jacob Skaria
"Ra" wrote:
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" wrote:
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
"Jacob Skaria" wrote:
Tools Options Spelling AutoCorrect Autocorrect and remove the
correction
If this post helps click Yes
---------------
Jacob Skaria
"Ra" wrote:
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
|