+ Reply to Thread
Results 1 to 3 of 3

VBA to open the Pivot Table and Pivot Chart Wizard

  1. 05-28-2017, 06:42 PM #1
    scottiex
    scottiex is offline
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,343

    VBA to open the Pivot Table and Pivot Chart Wizard

    What would be the VBA to open the "Pivot Table and Pivot Chart Wizard"?
    I want to attach it to a shortcut key
    If you want something done right... find a forum and ask an online expert.

    Time flies like an arrow. Fruit flies like a banana.
    Reply With QuoteRegister To Reply
  2. 05-28-2017, 07:37 PM #2
    scottiex
    scottiex is offline
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,343

    Re: VBA to open the Pivot Table and Pivot Chart Wizard

    I am guessing I just need to know the control id and have a line like

    Please Login or Register  to view this content.
    However I don't know the code.. arrgh where is a nice "this is the button's id" context menu when you need it!
    Reply With QuoteRegister To Reply
  3. 05-28-2017, 08:54 PM #3
    scottiex
    scottiex is offline
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,343

    Re: VBA to open the Pivot Table and Pivot Chart Wizard

    I realized Alt+D + P works
    No need to do it the hard way
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Open Pivot table Wizard shortcut commands ALT+D+P not working
    By CLemons in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-18-2015, 02:59 PM
  2. How can I use the pivot table wizard on this data
    By ammartino44 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 04-28-2014, 02:35 PM
  3. [SOLVED] Excel 2007 : Is it possible to change source data in pivot table and pivot chart wizard??
    By questionguy in forum Excel General
    Replies: 2
    Last Post: 04-16-2012, 05:06 PM
  4. Consolidated Pivot headache - can't get the same fields with Pivot Table Wizard
    By starstill in forum Excel General
    Replies: 0
    Last Post: 07-23-2011, 04:35 PM
  5. Multiple Sheets Into One Pivot table (Not Pivot Wizard) + Database Question
    By woontime in forum Excel General
    Replies: 5
    Last Post: 07-01-2011, 01:36 AM
  6. Excel 2007 : Pivot Table Wizard
    By scokaw in forum Excel General
    Replies: 5
    Last Post: 11-01-2010, 03:39 PM
  7. Excel 2007 : Pivot Table Wizard
    By mattyj in forum Excel General
    Replies: 1
    Last Post: 07-15-2010, 12:41 PM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1