If I remember correctly, Worksheet_Change event does not work on pag
fields in a pivot table.

The way I would approach this is to add a validation cell with
drop-down box that automatically gets populated with the values fro
the page field, and then use the Worksheet_Change event for that cel
to change the page fields in VBA

--
Kre
-----------------------------------------------------------------------
Krem's Profile: http://www.excelforum.com/member.php...fo&userid=2434
View this thread: http://www.excelforum.com/showthread.php?threadid=37939