VBA pivot table Insert Images- 20$

    Hi,


    VBA code.. show/hide only the images that was expanded/collapsed on the pivot table, since it's loading all images when expanding/collapsing the whole fields.


    PM for sample file.


    Transaction ID35N25611GV941410F



    br,

    I can have a look at this for you

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

    I have a solution ready, will PM you my PayPal details

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

    Payment received and code sent by PM

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

    What error do you get, and on which line of code?


    It all works for me, but then I had to hard code for the path to a picture.


    I could not update the paths in the data table because then refreshing the pivot caused an error because the power query tried to refresh too, but of course it could not.


    Could you send me a file containing all the images you have links to in the data table, and remove the power query from the data/pivot file.


    I can then do a full test of the code.

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

    Don't worry about the Data/Pivot file without the query, I have done that, but I still need the images to conduct a proper test.

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

    Got it, thanks, testing now

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

    Revised code sent via PM

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

    Also, when i filter the first and 2nd row.. the images doesn't show..


    Only show when the 3rd row was expanded.. but still the first row doesn't show the picture..


    Thanks.

    Revised code with error trapping sent via PM

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

Participate now!

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

Register Yourself Login