I am explaining my requirement. if someone can come up with an idea,
thats appreciable.

I have a pivot table which dynamically varies its position, based on the fact
that I check or uncheck some options on the pivot table. So, its position,
varies based on my selection.

Beneath the Grand Total for Columns, (ie) which comes under the row side Grand
Total, I am creating three rows. Right now, the three rows are created through a
click event of a button. But I want something like this.

When I uncheck or check something in the pivot table, i want my macro to run.
I felt that the worksheet_calculate event is a nuisance. Also, I dont want to
hit the button each time, when i do something with my pivot table.