+ Reply to Thread
Results 1 to 3 of 3

VBA scroll pivot slicer to top of list

  1. #1
    Registered User
    Join Date
    02-28-2014
    Location
    Liverpool, UK
    MS-Off Ver
    Excel 2010
    Posts
    4

    VBA scroll pivot slicer to top of list

    I have a pivot table and multiple slicers. I have a 'reset' button that clears all slicer selections, refreshes the table, deletes drill-down sheets, etc but I'd also like to set all slicer scroll bars to the top of each list. Clearing slicer filters doesn't do it.

    Is there any code I can add that will do this?

  2. #2
    Registered User
    Join Date
    08-16-2012
    Location
    Michigan
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: VBA scroll pivot slicer to top of list

    I need help in this one too!
    Any ideas?

    I can select top item and deselect every item below it but it doesn't move the slider bar to show top position item that has been selected.

    Only option I found was a suggestion to delete every slicer and use vba to recreate them in the same location and size. Doesn't seem like easiest solution but post said it would be created with the slider at the top. Any Any Any ideas out there?

  3. #3
    Registered User
    Join Date
    10-18-2012
    Location
    Lisbon, Portugal
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: VBA scroll pivot slicer to top of list

    Good morning,

    Has anyone found a solution for this?

    Thank you

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Why can't I have a slicer in my pivot chart
    By ACrossley1 in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 02-14-2014, 10:38 AM
  2. graph not displayed using slicer in pivot
    By abraham30 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-29-2014, 01:43 PM
  3. Slicer Not Recognizing Pivot Table
    By BigBadBill in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-31-2013, 12:22 PM
  4. Pivot Table (Slicer) Help
    By skate1991 in forum Excel General
    Replies: 0
    Last Post: 10-11-2012, 11:52 AM
  5. [SOLVED] Change Chart Title Depending on a Slicer - slicer advice
    By JungleJme in forum Excel General
    Replies: 8
    Last Post: 08-17-2012, 07:59 AM

Tags for this Thread

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