Discussion:
Loan amortisation Template
(too old to reply)
Dhananjay
2010-03-17 10:39:02 UTC
Permalink
Hi,
I opened a loan amortization template in this i can able to enter only date
in particularcells and some ranges are freezed so that the cells are not able
to activate at all . I am preparing some workings so i want to give like this
conditions to my users how to freeze or Lock to unactivate cells and freeze
in work sheet
Brad Vogt
2010-03-17 19:45:02 UTC
Permalink
There is no password to unlock the worksheet. Just go to the review tab and
click on unprotect sheet in the changes group. You will then be able to
select and change any cell. Note however that you are also able to damage
the formulas and functions in the sheet, so you must be careful.
Post by Dhananjay
Hi,
I opened a loan amortization template in this i can able to enter only date
in particularcells and some ranges are freezed so that the cells are not able
to activate at all . I am preparing some workings so i want to give like this
conditions to my users how to freeze or Lock to unactivate cells and freeze
in work sheet
Loading...