Consulting

Results 1 to 2 of 2

Thread: screen updating

  1. 01-16-2006, 04:44 AM #1
    rodney_malod
    rodney_malod is offline
    VBAX Regular
    Joined
    Nov 2005
    Posts
    25
    Location

    screen updating

    is there a way of stopping the screen going mad when excel performs functions on different pages? stop screen cycling....
    Reply With Quote Reply With Quote
  2. 01-16-2006, 04:45 AM #2
    Bob Phillips
    Bob Phillips is offline
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    [vba]
    Application.Screenupdating = False

    ... your code

    Application.Screenupdating = True
    [/vba]
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules