locked
Screen Updating RRS feed

  • Question

  • I am using the following code to stop the screen flashing when i jump between sheets.

    Application.ScreenUpdating = False

     

    But when I call one proceedure from another one, it takes no notice of the ScreenUpdating being set to False.

     

    Am I missing something?

     

    Wednesday, September 8, 2010 3:47 PM

Answers

  • Hi Gazza101

    try this code and replace your ScreenUpdating.

    Application.EnableEvents = False

     

    Hi there, is your problem already answered?

    • Edited by Dennis Hemken Tuesday, September 14, 2010 5:08 AM Problem Answered???
    • Marked as answer by Gazza101 Wednesday, September 29, 2010 3:21 PM
    Thursday, September 9, 2010 7:42 AM

All replies

  • Hi Gazza101

    try this code and replace your ScreenUpdating.

    Application.EnableEvents = False

     

    Hi there, is your problem already answered?

    • Edited by Dennis Hemken Tuesday, September 14, 2010 5:08 AM Problem Answered???
    • Marked as answer by Gazza101 Wednesday, September 29, 2010 3:21 PM
    Thursday, September 9, 2010 7:42 AM
  • Thanks Dennis
    Friday, September 24, 2010 10:59 AM
  • Hi Gazza101,

    please 'mark as answer' . Thanks


    Please 'Mark as Answer' if I helped. This helps others who have the same problem!
    Monday, September 27, 2010 1:49 PM