MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

based on pivot table position

  Asked By: Alex    Date: Aug 28    Category: MS Office    Views: 739

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.



1 Answer Found

Answer #1    Answered By: Edith Mcdonald     Answered On: Aug 28

Use the Worksheet_Change event  within that sheets module.

Private Sub Worksheet_Change(ByVal Target As Range)

'Your Code Here'

End Sub

Didn't find what you were looking for? Find more on based on pivot table position Or get search suggestion and latest updates.