Protect cells in unprotected sheet

[vorrl]

I have an excel workbook containing of user input cells (B3:C8) and cells containing formulas (E3:E8).
The entire workbook shall be protected, but users shall be able to unprotect it and add data into (B3:C8).
I'd like all other cells to remain protected

I know that I could achieve a result by protecting (B3:C8) with one password and the other cells with another passord, but can it be done without use of passwords?

 

[Joe4]

Welcome to the Board!

If that is really what you want to do, why bother protecting ALL the cells, if you want to allow users to unprotect certain cells so they can edit data.
Why not just protect all cells on the sheet except for B3:C8?
That way, users do not have to protect/unprotect anything, and can only edit the cells you want them to.

 

[vorrl]

I know, this would of course be the easiest way to do it - but I have been given a requirement that the entire sheet shall be protected when opening it

 

[Joe4]

I know, this would of course be the easiest way to do it - but I have been given a requirement that the entire sheet shall be protected when opening it

I fail to see the purpose, if you are just going to allow them to unprotect with no password.
Trying to have different levels of protection with no passwords really kind of defeats the purpose of using protection (since they can easily unprotect it).
I am not even sure that is possible.

I cannot think of doing what you want to do without using VBA, where you have different procedures to protect/unprotect different ranges.