Event Handlers for pivot

  • Hi,

    I'm got a pivot table in a sheet called "Pivot" which when the user drills down into the pivot by double clicking it opens up a new sheet with the data. I wanted the event handler to run a macro after the users double click. Got the below code but not working.

    Any thoughts ??

    Thanks in advance

    VBA Noob

  • Re: Event Handlers for pivot example

    Hi all,

    Think i've cracked it. My macro is called Fillcolors

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!