I want to fully protect my excel file so I have done the following:
Protect each worksheet with password.
Protect VBA project with password.
Protect workbook with password.
So far everything is fine.
But when I want to run macros the sheets can't be protected.
So I wrote a macro to disable and a macro to enable the protection.
Made a button which once clicked runs:
the macro to disable protection
the macro which I want to work
the macro to enable protection
Now I can run the macro and still have my file protected.
The problem is that now anyone can run the macro to disable the protection without knowing the password!