Results 1 to 1 of 1

Screenupdating doesn't work with multiple sheets

Threaded View

  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

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