+ Reply to Thread
Results 1 to 1 of 1

Screenupdating doesn't work with multiple sheets

Hybrid View

Boeckie Screenupdating doesn't work... 05-15-2014, 09:52 AM
  1. #1
    Registered User
    Join Date
    05-15-2014
    MS-Off Ver
    Excel 2003
    Posts
    1

    Screenupdating doesn't work with multiple sheets

    I have written a long code which calls other subs and I'm using the screenupdating set to false for each macro.
    I define the sheets in the code with variable names to make it clearer in the coding when I'm switching worksheets.

    Now, when I look to the Locals window, to the values for the different sheets involved, I find myself looking at the Screenupdating still set as True for the different sheets (see attachment).
    I think that this is what causes my screen still to flicker, even when I specify at the beginning of the macro that the screenupdating needs to be false.

    Does anybody knows how this can be solved?


    Thanks

+ 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. Excel VBA Formatting doesn't work on protected sheets?
    By meissen in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-01-2013, 12:09 PM
  2. [SOLVED] Range data type doesn't work with ranges from other sheets?
    By lakehaze in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-13-2012, 06:32 AM
  3. Create PDF files from multiple work sheets in a single work book
    By erprasannaa in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-29-2012, 03:42 AM
  4. Macro that should create csvs of all the sheets of a workbook doesn't work! help!
    By scantron in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-15-2012, 12:46 PM
  5. macro doesn't work on hidden sheets
    By jseufert in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-13-2009, 05:57 PM

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