+ Reply to Thread
Results 1 to 2 of 2

Control Multiple Slicers With Macro

  1. #1
    Registered User
    Join Date
    10-19-2019
    Location
    Australia
    MS-Off Ver
    MSO365
    Posts
    1

    Control Multiple Slicers With Macro

    Hi
    I want to make a macro or macros that will run when the file is opened. These macros need to do the following:
    1. Select Day Slicer and click on the Multi Select Button so that Multi Select is ON
    2. Select the MONTH Slicer and do the same thing
    3. Select a specified cell and change the value in that cell from YES to NO
    4. Select another specified cell which is empty

    I have found that no matter which technique I use for sequencing these steps, I can only get one Slicer selected and have its MultiSelect button set to ON.
    I have tried:
    All steps in one macro
    Separate macros for each step with the next macro called at the end of the previous one
    Listing all the macros in one 'on open' workbook macro

    Any help would be greatly appreciated
    Raz Ellen

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Control Multiple Slicers With Macro

    Post the code you've tried so far.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

+ 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. [SOLVED] Macro to Run when Slicer Selection is Changed (multiple slicers)
    By jcanlas in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-09-2021, 11:41 AM
  2. Slicers to sync multiple pivots from multiple data sources?
    By cantona_lives in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 06-21-2017, 12:33 PM
  3. Help with macro with slicers
    By moosmahna in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-05-2017, 02:45 PM
  4. Connecting multiple slicers
    By kaleonard08 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-09-2016, 03:34 PM
  5. [SOLVED] Disconnect Slicers, Change Pivot Table Source, Reconnect Slicers: a problem
    By Geoff. in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2015, 02:27 PM
  6. Filter Multiple Tables with one set of Slicers
    By palmer266 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-21-2015, 09:04 PM
  7. Control Y Axis on Pivotchart when using Slicers
    By karl_popper in forum Excel General
    Replies: 3
    Last Post: 12-06-2012, 02:40 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