+ Reply to Thread
Results 1 to 3 of 3

Slicers/Checkboxes disappearing during macro run

  1. #1
    Forum Contributor aprildu's Avatar
    Join Date
    04-13-2014
    Location
    Barrie,On, Canada
    MS-Off Ver
    Excel 2016
    Posts
    175

    Slicers/Checkboxes disappearing during macro run

    On the sheet I have some slicers (data table slicers) and checkboxes. They disappear when the macro is running but they appear again after it's over. It's not a bug per se but I am asked if there's anything can be done to keep them showing on the screen when the macro is running. The macro has some copy pasting to different sheets and I have set some of the sub routines screenupdating to false. My guess is it has to do with screenupdating? Any help appreciated!
    Last edited by aprildu; 01-19-2018 at 12:47 PM.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Slicers/Checkboxes disappearing during macro run

    Your guess is probably correct:
    Add Application.Screenupdating = False
    near the top of your code
    and
    Application.Screenupdating = True
    near the bottom
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Forum Contributor aprildu's Avatar
    Join Date
    04-13-2014
    Location
    Barrie,On, Canada
    MS-Off Ver
    Excel 2016
    Posts
    175

    Re: Slicers/Checkboxes disappearing during macro run

    Thanks. But it doesn't work. What I meant is screenupdating is the reason for the shapes to disappear temporarily however I have to use screenupdating otherwise it will be flickering like mad. And I have to copy paste to another sheet as well (well if i have to make big changes to my routines that's another story - if it's worth doing just for the shapes disappearing).

    I did a workaround such as move the cursor to the area far from the shapes so users won't see the shapes at all when running but I wonder if there actual is a code to deal with it.
    Last edited by aprildu; 01-19-2018 at 04:25 PM.

+ 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. Help with macro with slicers
    By moosmahna in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-05-2017, 02:45 PM
  3. disappearing checkboxes
    By chrishuning in forum Excel General
    Replies: 6
    Last Post: 07-27-2016, 12:24 PM
  4. [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
  5. Align Slicers on worksheet with Macro
    By dkmanley in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-12-2015, 11:00 AM
  6. Excel 2010 Slicers : use vba macro to only select last date listed ( always Now - 1 )
    By spencerpritchard in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-06-2014, 02:25 PM
  7. Print Sheets based on checkboxes in UserForm, Checkboxes also control another macro
    By krackaberr in forum Excel Programming / VBA / Macros
    Replies: 34
    Last Post: 03-05-2013, 11:12 AM

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