The error resume next - error goto 0 is not solution I can use. He the
chooses the default filter "All" so every value is shown. What I want him to
do his quite making the specific pivottable. Is this something which is
possible:

So how to program a macro which indicates that if a cell value is not in the
page field list, he should not create the pivot, and if it is in the
pagefield list, he should create it.