02-01-2019 03:35 PM
02-01-2019 03:35 PM
02-02-2019 12:57 AM
Hello @Sotannde Abiodun Kabir ! There are at least 2 ways to realise a strong protection.
1. Go to your worksheet you want to protect.
2. Select the range of cells, which should be ONLY for inserting numbers.
3. Right-click on one of those selected cells.
4. Go to the last tab in this dialogue, "Protection"
5. Deactivate the cell protection for these cells.
6. Click on tab "Review" - click on Sheet protection. Activate only the second hook.
7. Give a password.
8. Now your password is a protection for all the cells NOT been protected.
9. If you click on one of your cells you ll see that your formulas are protected.
10. BUT: The range you didn't protect is yet ready to insert content like numbers.
This is only 1 way.
The second in my mind is the following:
1. If you have VBA then go to your VBA environment in this workbook with shortcut ALT + F11. In your left navigation (Project Explorer of Modules and objects) reduce your objects views so that all your modules and objects are not shown in the second area (the code procedures).
2. Go to the last Tab "Extras" - click on the second last option about properties of your VBA Project.
3. Click on second tab in this dialogue. Disable the ability to show reduced Modules (Hook).
4. give a password.
I attached screenshots for you. Additionally you should think about the options to migrate your Excel database (broadsheet) to SharePoint and Office 365 to share your file as an Excel Online workbook within OneDrive or SharePoint. Then its easier to figure out, which person has access and which changes will be accepted or denied in future. Go on with learning! and its free for eductional / non profit orgs to get an Office 365 environment. Unfortunately your VBA Code wont work anymore i have to admit. But in the long run your profit would be immense.
02-02-2019 07:58 AM
IMHO, worksheet protection is relatively easy to remove, doesn't matter how strong password do you use. Perhaps some third party utilities like https://doneex.com/protect-excel-formulas/ could help, didn't play with the. But that will be VBA inside.
02-02-2019 01:49 PM
02-02-2019 01:58 PM