Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2007
    Posts
    127

    Unanswered: Command Button in Pivot Chart

    How do i add a command button (macro) to a Pivot Chart. As my doesn't allow me to select the command button from the Control Toolbox.

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Howdy. In regard to both questions, I wonder if it might be better to consider making the Pivot Table and Chart all in VBA. Bill Jelen, et al, VBA and Macros for MS Excel, chapter 12 have code examples and instructions about how to do all this.

    The VBA approach gives you much more control, and in the long run can be faster than what you are trying now.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Oct 2003
    Posts
    1,091
    If you want just a button connected to a macro, then instead of using the Control Toolbox, use the Forms toolbar which you can draw on the Pivot Chart.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •