I have a code attached to a "change" event that executes after an unrelated
pivot table refresh button. Since it isn't expected to execute at that time,
I get error messages and failures. I'm a SAS programmer and not very
familiar with VB. Naturally, there's an unrealistic deadline and I'm
pleading for help.

Here's the error:
Run-time error '1004'
Unable to get PivotFields property of the PivotTable class.

On debug, I am taken to a sub routine that is called from a change event
from a list box on the same page that holds the button which was pressed (to
generate the error). Also, when the change control is activated directly,
there is no error and the code works fine.

I'd send the whole thing, but I think it would be too big (due to the
underlying databases)