I have created a macro that sets up a Pivot Table, including a Filter, which ends by doing the "Show Report Filter Pages" Option.
It does exactly what I want, save for one thing - when it puts the results on individual sheets, the filter is as it is in the Pivot (live, or able to be refiltered). I want it to be "locked" or absolute for that one result, so it cannot be refiltered.
Is there a way to do that?

Thank you in advance for your help!