+ Reply to Thread
Results 1 to 3 of 3

Excel 2013 user form is flickering when it wasn't in Excel 2010

  1. #1
    Registered User
    Join Date
    01-05-2014
    Location
    France
    MS-Off Ver
    Excel 2003
    Posts
    5

    Excel 2013 user form is flickering when it wasn't in Excel 2010

    Good evening friends,

    I prepared a macro using VBA for Excel 2010 that used a user form (and screenupdating=false) to display a progress bar. It worked fine, but my work has just updated to Excel 2013 and although the macro works, the problem is that the screen flickers.

    I have had a look, and the problem is that I use the command:
    Please Login or Register  to view this content.
    This appears not to be an issue in Excel 2010 because it doesn't use (by default) multiple instances of the application.

    My macro doesn't use activate or select commands, because I was being really careful, but when I add a workbook the new workbook is activated; this causes my screen to flicker.

    Is there a way to add a workbook without activating that new workbook (ie: without losing focus of active workbook)?

    Any help is appreciated.

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,530

    Re: Excel 2013 user form is flickering when it wasn't in Excel 2010

    Are you turning off screen updating before adding the workbook(s)?
    If not you can do that and then after the last workbook(s) is added activate the sheet of your choice and turn screen updating back on.

    You could post the code also, maybe you are missing something that we can add for you.

    Make sure to use code tags. Highlight any code you post and click the # symbol on the tool bar. This will put a code tag at the beginning and ending of your code.

    You code after saving your post, instead of looking like this:
    Sub Test()
    End Sub

    Will look like this:
    Please Login or Register  to view this content.
    Last edited by skywriter; 09-09-2015 at 08:00 PM.
    As a reminder, once your original request has been fulfilled please mark this thread as SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

    If you are happy with my help, then please consider clicking the add reputation button in the lower left hand corner of this post.

  3. #3
    Registered User
    Join Date
    01-05-2014
    Location
    France
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Excel 2013 user form is flickering when it wasn't in Excel 2010

    In my code, I turn the screen updating off at the very start of the project, which looks like below (minus some details). Due thanks to Excel 2003 VBA for Dummies for the main structure.

    I could turn off the screen updating, but it would still cause the page to flicker. I am striving too much?

    Just to confirm, Excel 2013 is being a pain because it insists you open each new workbook in a new instance of the application. If I didn't have to do that, and have all books in one excel instance then I'd be happy.

    Please Login or Register  to view this content.

+ 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. Macros work perfectly in Excel 2010 but generate some errors in Excel 2013
    By Mumps1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-17-2015, 12:45 PM
  2. VBA formatting macro that worked in Excel 2010 is not working correctly in Excel 2013
    By jayar2112 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-10-2015, 01:14 PM
  3. Excel 2010, Excel 2013 BeforePrint Event Trigger (Before Print Preview)
    By mikepfly2 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-13-2015, 03:43 PM
  4. [SOLVED] User Form Image Flickering Problem VBA
    By lulupatel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-16-2015, 06:07 AM
  5. Macro code working fine in excel 2013 but not in excel 2010.
    By sere in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-10-2014, 02:23 AM
  6. Excel VBA 2010 - Grid Table in User Form
    By mythilisub in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-09-2013, 06:33 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