Posts by spirkd

    Re: Filter pivot table with selected items. Does not work with numbers.


    I kind of tricked it and now works for any type of value.



    But still, can someone explain what was wrong with the first code?
    I am just curious.

    Hello everyone,


    I wrote a simple macro with which to filter a pivot table with the items that I have selected.


    When the items in the Pivot Field are not numbers, it works perfectly.
    But when the items are only numbers, it just doesn't work and I don't understand why and how to make it work.


    Any ideas or tips ?
    Thank you in advance!


    Re: Add Excel Right Click Menu in Add-in


    Roy, thank you a lot for the reply and the files.


    Although I already managed to make it by myself, you showed me a slightly different method.
    So I will get deeper in the file and learn it as well.


    Thank you again!

    Hello all,


    I need your help for a very easy problem (I hope).
    Here is my case : I have written some macros and created Right Click Menu from where to reach them. So far so good.
    But also I want to create an Add-in so that I can distribute these macros with the right click menu buttons to other people.


    I used this tutorial to create the menu - http://www.ozgrid.com/VBA/right-click.htm
    However, saving the file as Add-in doesn't work. The created righ click menue does not appear on other Workbooks.
    The macros work, fortunately.


    Another thing that I tried was to change Temporary:=True to False (No Add-ins created).
    Then I have the buttons on every workbook, Macros work, but the Workbook with the written code always opens automatically as well, which I want to prevent.


    Okay guys, this is my problem, I hope that somebody will be able to help.