+ Reply to Thread
Results 1 to 2 of 2

Slicer Visible / Mac VBA

Hybrid View

  1. #1
    Registered User
    Join Date
    06-29-2010
    Location
    Manassas VA
    MS-Off Ver
    Office 2010
    Posts
    16

    Slicer Visible / Mac VBA

    Trying simply to hide a slicer using VBA on Mac. Looked in Object Browser but don't see a Visible method for the Slicer object. Is it not possible to use VBA to hide a slicer on a Mac??

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,998

    Re: Slicer Visible / Mac VBA

    The Slicer doesn't have a Visible property in any environment. You need to hide its Shape instead.
    Everyone who confuses correlation and causation ends up dead.

+ 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. Getting Slicer Visible Items only and using in a Filter formula
    By ptmuldoon in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-05-2020, 01:25 PM
  2. Disconnect Slicer, Change Pivot Source, Reonnect Slicer
    By ensi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-27-2020, 04:26 AM
  3. Show value of highest slicer selections (multi selected items in slicer
    By saudi_red_neck in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-01-2020, 05:37 AM
  4. Loop through slicer, while also selecting single slicer value on separate slicer
    By as_sass in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-30-2018, 01:41 PM
  5. Replies: 1
    Last Post: 04-23-2018, 09:43 AM
  6. [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