Screenupdating not working

posted by | Leave a comment

In column A I put 28 =RAND() formulas, and then in columns B: V i put very simple formulas that linked back to column A.This gives me 616 cells that will change on each calc, and its easy to keep all 616 cells visible on the screen.Open("C:\sample.pps", _ With Window:=mso False) 'Open a window now to the presentation for editing p Show.

' -------------------------------------------------------------------------------- ' You are free to use this code within your own applications, add-ins, ' documents etc but you are expressly forbidden from selling or ' otherwise distributing this source code without prior consent.The VBA code times 10000 calculations with Screen Updating Off and again with Screen Updating Nn.The difference between these is the time taken by the screen updating.You can verify this by launching Word the old-fashioned way and opening File1 at the bottom of the File menu after running the sample code.Although it would be difficult to do an exhaustive test, in theory this should work from any Automation client-Visual Basic, Excel, Power Point, or any other.

Leave a Reply

Xxx chatting message