Wrap Column B on Pivot table.

[Livin404]

Hello I have a database entry sheet where the results are given with a Pivot table. In Column B I have remarks but in order to read the full remarks, I have to unlock the sheet then format.
I tried the following macro with no success. It's on a protective sheet. I only need Column B.

Thank you in advance.

Private Sub Worksheet_Change(ByVal Target As Range)
   ws.Unprotect Password:="mozzer"
   .WrapText = True
   ws.Protect Password:="mozzer"
End Sub

 

[GlennUK]

In what way does it not work? Are you sure it gets triggered anyway?