A colleague gave me the solution:
The worksheet was protected to prevent writing, but needed unprotection
to do a "find and replace".
Solution, unlock the relevant column for the "find and replace",
therefore, the macro doesn't need to unprotect the entire sheet. All
columns are protected but that one.

case closed
:-)

PUBA