Results 1 to 5 of 5

Help on how to stop screen flickering

Threaded View

  1. #1
    Registered User
    Join Date
    11-03-2011
    Location
    detroit, us
    MS-Off Ver
    Excel 2007
    Posts
    24

    Help on how to stop screen flickering

    Hi all,
    I am trying to stop screen flashing when selecting slicer from the ‘summary sheet’:

    Sheet1: data in pivot table

    Private Sub Worksheet_Change(ByVal Target As Excel.Range)
    Application.ScreenUpdating = False
    If Not Intersect(Target, Range("b12")) Is Nothing Then
    Range("b2:k15").Copy (Worksheets("summarysheet").Range("b41:k95"))
    End If
    Application.ScreenUpdating = True
    End Sub

    Sheet2: data in pivot table


    Private Sub Worksheet_Change(ByVal Target As Excel.Range)
    Application.ScreenUpdating = False
    If Not Intersect(Target, Range("b12")) Is Nothing Then
    Range("b4:s8").Copy (Worksheets("summarysheet ").Range("b18:s22"))
    End If
    Application.ScreenUpdating = True
    End Sub

    Sumarysheet --- has slicer in power pivot - the flickering occurs when slicer is select.

    Other than the code works fine. I though the Screenupdating method will handle that , but no luck.


    Any help would really appreciated
    Last edited by Kevin_M; 11-07-2015 at 08:40 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. flickering Screen
    By love2waltz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-02-2015, 08:08 AM
  2. [SOLVED] How to stop Screen Flickering when Code Hides and Unhides Rows
    By martystoked in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-23-2013, 10:57 AM
  3. VBA code to stop screen from flickering does not work
    By joy_ in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-12-2012, 11:30 AM
  4. Screen flickering. Too much code?
    By MarcoAUA in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 03-05-2012, 12:14 AM
  5. Replies: 1
    Last Post: 03-11-2010, 08:18 AM
  6. Screen flickering while filter is running
    By Marco-Kun in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-17-2009, 10:50 AM
  7. Flickering screen
    By ledzepe in forum Excel General
    Replies: 1
    Last Post: 12-12-2006, 10:54 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