+ Reply to Thread
Results 1 to 1 of 1

Controlling Pivot Table via Coded Buttons

  1. #1
    Registered User
    Join Date
    03-18-2009
    Location
    Monroe, MI, USA
    MS-Off Ver
    Excel 2003
    Posts
    1

    Controlling Pivot Table via Coded Buttons

    I have several macro coded buttons that control a pivot table. I can successfully control the Page and Row Fields but am having trouble controling the Data Item Field as it removes the data when you Hide or Deselect a Data Column. I recorded the action of deselecting the data items and have been able to, through the coded button, to mimic the removal and addition of a data item however once the code for that button is run it changes the behavior of my other buttons. Any ideas?
    Attached Files Attached Files
    Last edited by Chasmojr; 04-03-2009 at 08:45 AM. Reason: added attachment

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1