I'm trying to indicate in cell E1 whether protection for my worksheet is on or off.

I tried this in CF

=CELL("protect",E1)=0
but don't find it responds after protecting / unprotecting the worksheet.

I wondered is some event VBA could provide some simple text and a change of colour in E1 to show worksheet protection status.

Can someone suggest some VBA to satisfy this?

Grateful for any advice.