VBA - synchronize multiple pivottable pagefilter

A

Andre

Hello, I am working with Excel 2007.
I found a piece of VBA code on the internet that synchronizes the pagefilter
in different pivottables. This code is only working when I am saving the
excel file in the XLS format. When I save the file in the xlsm format then
the VBA code is not working. The code is watching the change of a pivottable
page filter, when you select one item then the code is working, when you
enable the "select multiple items" filter then the code doesn't work i got an
error "runtime error 9" "Subscript out of range". the debug stops at this
line:

If Target.CubeFields(pagefld.Name).EnableMultiplePageItems = True then

the filterfield is a year-month hierarchy.

Does anyone knows why this is happening.

Thanks,

André
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I figured out the issue thank you. 0
How can I get a Shareable URL via VBA code to a OneDrive image? 0
VBA Filtered Pivot Table Showing "Multiple Values Selected"; Only One Value Selected 0
Working outlook via vba code with xlsx - error 0
Change report firlds in pivot tables and charts with one selection 0
PivotTable 2003 Code is not working 0
Dynamic Naming of Form Button 3
Need Help with a VBA subroutine 0

Top