Explanation:
First level security is when you
lock file:
In order to unlock and access you
have to set password for file as per below step.
- Go to excel file then click File –
Save As.
- Choose location where you want to
save it, Folder, Desktop.
- In the Save As dialog box, choose
the specific folder you like, after that click Tools and after that
click General Options.
- You will get a dialog box named -
Generals Options where you can set password to open file and
password to make modification in file – set a password for
both.
- Then Click Save.
Second level of security is to lock
worksheet.
In order to Secure Worksheet you
have to protect that Worksheet.
- You will see Review tab on tab menu
click on that, then you see Protect Sheet option click on
that.
- Dialog box will open where you can
set area you want to allow user to modify, Choose the area.
- You have to check the Protect
worksheet and content of locked cells and enter a password in
Password to unprotect sheet to protect sheet from
getting open and modify.