If it just happened once I would consider it a glitch. You shouldn't be able
to unmerge on a protected sheet. If it repeatedly happens with this user, I
would troubleshoot the user.
Mike F
"Pete" wrote in message
oups.com...
Hi

For some reason one of the Cells in a Protected Sheet was "unmerged",
which through out some calculations relying on that cell, any ideas how
this can happen on a Protected Sheet.

The operator is very inexperienced with Excel, so may have
inadvertently done something to unmerge the cells, although I have
tried, I cannot achieve this.

Pete