The cells  i hide  have to be where they are as they represent the value
of the holiday taken. I hide these rows  with a toggle button  so that i
can have a better overwiew of staff who are on holiday.

If someone was to delete some info by highlighting more than one row
then the hidden  cell values get deleted as well.

So i need to protect these cells when they are hidden and unprotect
when they are not.

I can do one or the other but i can't do both procedures using the same
button.

If i send you the spreadsheet would that help  you see what i'm trying
to do?