Run-time error '1004' despite UserInterfaceOnly = TRUE

Hi all,

I have locked all my pivot sheets and set UserInterfaceOnly = TRUE so that I can run my Macro to select and deselect items in a Pivotfield without having to unlock and lock all sheets again. This works fine for the following code:

Please Login or Register  to view this content.

Though, if I do the same with below code. It gives me an "run-time error '1004' - cannot edit pivot on protected sheet" and highlights the .ClearAllFilters line when I debug. Does UserInterfaceOnly = TRUE only work for certain type of codes??

Please Login or Register  to view this content.

What does the code, with "UserInterfaceOnly = TRUE", look like and where is it located ?

It is in the ThisWorkbook section and looks like this:

Please Login or Register  to view this content.

That's not what I was hoping to hear, but at least it explains why it doesn't seem to work for the above case. Thanks for enlightening me!